Two "if"s in a formula
 

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!

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!

Two "if"s in a formula
 

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


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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!

Two "if"s in a formula
 

Try something like this:

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

Note: that will return TEXT of "$1.09"

If you want it to return a numeric value, use this formula and format the
cell as currency:
=IF(OR(D38=1.09,D38=4.49),1.09,0)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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!

Two "if"s in a formula
 

Thanks for your help! It worked!!!!

"Ron Coderre" wrote:

Try something like this:

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

Note: that will return TEXT of "$1.09"

If you want it to return a numeric value, use this formula and format the
cell as currency:
=IF(OR(D38=1.09,D38=4.49),1.09,0)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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!

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!