Question

Locked

Do nothing in an excel formula

By rovest ·
I want to write an "if" statement that if the value is false I want excel to do nothing, (not a 0 or anything). I want it to leave the data in the cell that is already there. Ex:

Formula in cell a6
=if(a2="April",b5+b6+b7,do nothing)

That way if I change the month to May I can enter the formula in c6:
=if(a2="May",b5+b6+b7,do nothing)
and it will keep the data in a6

I hope I explained this okay. Any help would be greatly appreciated!!!

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

Clarifications

Collapse -
by niessen

Did you ever get an answer (or figure out one) for this? The "" clearly doesn't work since it puts a nul in the cell . . . but, more importantly, it erases the number we want to save!

All Answers

Back to Software Forum
4 total posts (Page 1 of 1)  

Software Forums