IF? for a result?

[go77377]

Sometimes a formula that should be so simple really gets the best of me.

Can some advise me of what I'm doing wrong?

Below is the formula....

=IF(H9="2",(D9*13)),IF(H9="3",(D9*20))

All I'm trying to do is where ("H9="2") is to multiply the formula, then if (H9="3") then multiply that formula and place it in the cell. The cell the result would be placed in is (I9).

Is this enough info or did I leave something out?

 

[Fluff]

If H9 is a number rather than text remove the quotes

 

[go77377]

When I remove the quotes, the result says "FALSE". It should display 2.47, because the number in "D9" is (.19)

 

[Fluff]

What do you get if leave the quotes?

 

[go77377]

Result is "False".

 

[Fluff]

How about
=IF(H9=2,D9*13,IF(H9=3,D9*20))

 

[go77377]

That worked, Thank You, Thank you!!!!!

 

[Fluff]

You're welcome & thanks for the feedback