IF Function

[completelogistics]

I NEED HELP, PLEASE!!!
I am in need of some assistance regarding the IF function (for office 2003). I know what I want the cel to do but I don't know how to write the equation.

Here is what I want it to do;
IF cel H3 is >1, then multiply cel F3 by 0.123, if cel H3 is <2 then multiply cel F3 by 0.456.

Is there a limit to how many portions of the equation I can put into this?

Any help would be greatly appreciated.

Thanks.

 

[kpark91]

I think you can put up till 7 if statements.

=IF(H3 > 1, F3 * 0.123, IF(H3 < 2, F3*0.456))

Btw, the conditions you have given us does not consider the case between 1 and 2 but it might be intended so I left it be.

 

[Jonmo1]

Welcome to the board...

You can only nest 7 IF's.
But it sounds like this would be better off using a lookup.

But need clarifaction..

IF cel H3 is >1, then multiply cel F3 by 0.123, if cel H3 is <2 then multiply cel F3 by 0.456.

What if H3 = 1.5, should it be 0.123 or 0.456 ? Both > 1 and < 2 are true..

Be specific, and spell out the entire purpose of the function.
I'm sure it can be resolved.

 

[completelogistics]

Thanks!!!

There is no in between whole numbers. It is either 1 or 2 but I will have a need to go up to 15 with no decimal.

 

[Scott Huish]

=IF(COUNT(F3,H3)=2,F3*CHOOSE(H3,0.123,0.456),"")
Add the rest of your 13 items in the CHOOSE function.

 

[completelogistics]

HotPepper;

I'm not sure I understand.

My desired destination is to have the following;

If cel H3 = 1, then multiply F3 by .123
If cel H3 = 2, then multiply F3 by .456
If cel H3 = 3, then multiply F3 by .789
all the way to
If cel H3 = 18, then multiply F3 by .000123.

The cel H3 is to determine what number cel F3 is multiplied by. I would like to have this all in one equation as I will never know ahead of time what the value of cel H3 will be. This way I won't have to alter the cel each time I put a value into H3.

Does this make sense? I hope.

Thanks.