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

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?

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

Please Login or Register  to view this content.

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?

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

Please Login or Register  to view this content.

If you're not bothered about the text

Please Login or Register  to view this content.

Hopefully that covers all the bases
Cheers

Thanks works perfect