Have the content of a cell only show if another cell has an entry

[mikerules]

I have a sheet that has an entry of $100.00 in H18 however I only want this to show if an entry is made to H10. If H10 is blank then H18 should be zero.

Is there a way to do this?

[Philb1]

Hello Mike
If you put this in H18, it'll be blank if H10 is blank, anything in H10 & it'll show 100. Format H18 to currency, change the decimal point to suit & it'll show in currency format
Cheers

=IF(H10<>"",100,0)

[mikerules]

That works great but is it possible that if it is o rather than blank that as well would result in H18 also being blank. In other words a number greater than 1 would have to be entered in order for H18 to populate?

[Philb1]

Any number greater than 1 in H10, H18 will show 100, any text or any number less or equal to 1 entered into H10, H18 shows 0

=IF(OR(ISTEXT(H10),H10<=1),0,100)

If you're not bothered about the text

=IF(H10>1,100,0)

Hopefully that covers all the bases
Cheers

[mikerules]

Thanks works perfect