Excel IF Function

  • Thread starter Thread starter Mark
  • Start date Start date
M

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?
 
Worksheet functions can't change values in other cells. However, you
could use:

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

and format as currency.
 
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)
 
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?
Click to expand...

In H4 put the formula:

=1.95*(O4<>"Y")


--ron
 
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
 
Back
Top