Thread: [Solved] WHEN formula
View Single Post
 
Old 01-31-2014, 06:53 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

If formulas need to have an else statement. If you write a VBA statement you can skip the Else statement but the complication goes up and you will want to get ready to learn.
I think you can accomplish what you need with a formula.
The formula that I would use if it were me would be
=if(B1=1,C1,"")
This will keep the formula cell blank unless the condition is met.
Reply With Quote