simple question I think

**1newguy** · 03-05-2009, 04:48 AM

I am trying to hide a value in M18- when I fill in B18 there is a value of -100%
I want that cell to remain empty until F18 has a value-

this is what I have now-

HTML Code:

I added this to my M18 cell
thanx in advance

**DonkeyOte** · 03-05-2009, 05:02 AM

Perhaps

=IF(COUNT(B18,F18)<2,"",(F18-B18)/B18)

Though if B18 is 0 you will get #DIV/0! -- you could use Data Validation on B18 to preclude 0 as permissable value or

=IF(OR(B18=0,COUNT(B18,F18)<2),"",(F18-B18)/B18)

**Steve R** · 03-05-2009, 05:03 AM

What is the value in B18 and F18?

**mudraker** · 03-05-2009, 07:07 AM

1newguy

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request