Two "if"s in a formula
Try
=IF(D38=1.09,"$1.09",IF(D38=4.49,"$1.09",0),0)
"cwilliams" wrote:
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!
|