Having trouble with if then statement

[hipmrc]

Hi All,

I am trying to do the following: in my workbook H34 (It is actually H,I,J as those three fields are merged) is H12 (H,I,J) * 100

I need to write a formula so that if H34 is less thqn $2500 it will multiply the number of locations (H12 x $100), but if H34 is $2500 or more it will enter the number $2500 (in other words it is number of locations H12 X $100 with a cap of $2500.00)

Here is the formula I cam up with that of course does not work. (I don't understand how to put the original H12*100 into the formula)

=H12*100,IF(H34<2500,"G12*100",IF(H34>=2500,"2500",))

If anyone can assist me I will truly appreciate it.

Thank you

hipmrc

 

[Scott T]

I think this is what you want.

=if(H12*100<2500,H12*100,2500)

 

[Joe4]

Welcome to the Board!

in other words it is number of locations H12 X $100 with a cap of $2500.00

If that is truly the case, you can simply use:

=MIN(H12*100,2500)

 

[FDibbins]

Or, if 2500 will always be the max...
=min(2500,H12*100)
if H34 is less thqn $2500 it will multiply the number of locations (H12 x $100), but if H34 is $2500 or more it will enter the number $2500

ha, need to refresh more often lol

 

[hipmrc]

Welcome to the Board!


If that is truly the case, you can simply use:

=MIN(H12*100,2500)

Thanks very much! You make it look so easy

 

[hipmrc]

Thanks for the welcome Joe4!

 

[Joe4]

You are welcome!

It can be easy, when you know a lot of the tricks and different functions!
That comes with experience.