Function Help Working with a Zero Value

[Brenda42]

I'm having trouble resolving what is probably something very simple. I'm using the function IF(L7=0,"",L7-2), the problem is that how do I write this to work if the cell value is a Zero?
Thanks
Brenda

[NBVC]

Not sure I understand.

Can you explain it further?

[Brenda42]

Sorry, using the following as an example IF(L7=0,"",L7-2). I use this to to calculate cell values based on the value of L7. It works with any number other than zero. It doesn't come up often, but if a zero is placed in L7, no calculations are made.

Thanks
Brenda

[NBVC]

That is because the formula is saying that IF L7 equals 0, to return a "blank". Just remove that part...

e.g. =L7-2

[Brenda42]

Thanks, this is one of those have your cake and eat it to moments. We have it set that way due to the spreadsheet being posted on an in-house website. If we have =L7-2, and no value is input in L7 (occurs often) then cells L8:L15 keep their previous value. I'm just tinkering with ideas on how to make this work and look good and the same time.

Thanks for all of the help
Brenda

[NBVC]

If you use:

=IF(L7="","",L7-2)

then this will leave cells blank if L7 is blank and only evaluate if L7 has an entry in it.

[Brenda42]

I tried that and if L7 is 0 then L8 is blank. Sorry for the trouble.