Thread: Do nothing in excel formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Do nothing in excel formula
You need a macro.

--
Don Guillett
SalesAid Software

"rovest" wrote in message
...
I am trying to write a formula that will leave the current value in a cell
if
the condition is not true. Ex:

=if(c3=april, d5+d6+d7,?)

The question mark represents "doing nothing". No 0, blank or anything. I
just want to leave the data that is in the cell alone if the condition is
not
met. Any help would be greatly appreciated.

Reply With QuoteReply With Quote