Excel IF 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?

 

[J.E. McGimpsey]

Worksheet functions can't change values in other cells. However, you
could use:

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

and format as currency.

 

[Bob Phillips]

Mark,

Why re-post?

See the earlier question.

--

HTH

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

 

[Ron Rosenfeld]

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?

In H4 put the formula:

=1.95*(O4<>"Y")


--ron

 

[GB]

Mark,

Why re-post?

See the earlier question.

Are there delays in Posts appearing?

 

[Bob Phillips]

Haven't noticed any delays particularly, but I have been finding that many
of the posts are not now available on the server, and the only way I can
look at them is in Google.

Bob