View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 65
Default Two "if"s in a formula

Try this:

=IF(OR(D38=1.09,D38=4.49),"$1.09","0")



"cwilliams" wrote in message
...
I am not getting any result with this formula. I have tried it two
different
times.

When I use this:
=IF(D38=1.09,"$1.09",0),IF(D38=4.49,"$1.09",0)
I get #Value!

When I use this:
IF(D38=1.09,"$1.09",0)*IF(D38=4.49,"$1.09",0)
I get 0

I am trying to have the cell either say $1.09 or $0

Can someone please help? Thanks!