Excel Function

[Mark]

I have a value in cell H4 of $1.95 I want to have this cell change it's
value to $0.00 If I type in a Y in cell O4 and if possible back to
$1.95 if I remove the Y from O4. I have not been able to do any of
this and it is driving me crazy. Anyone have any ideas?

 

[Bob Phillips]

Mark,

In H4, put

=IF(O4="Y",1.95,0)

and form at the cell a currency.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)