Simple (I bet) Newbie question...

[Edward]

I hope this is possible to have happen all in 1 formula


How can i compose a formula that would acheive the following:


If the number in J5 is at least 10,000 but up to 24,999 then multiply cell
I5 X B5
If the number in J5 is at least 25,000 but up to 49,999 then multiply cell
I5 X C5
If the number in J5 is at least 50,000 but up to 99,999 then multiply cell
I5 X D5
If the number in J5 is over 100,000 or above then multiply cell I5 X E5
If the number in J5 is UNDER 10,000 then display "Under Min" (or something
like it)


Thanks for reading!!

 

[Per Jessen]

Hi

The formula should be entered as one line!

=IF(J5<10000,"Under
Min",IF(J5<25000,I5*B5,IF(J5<50000,I5*C5,IF(J5<100000,I5*D5,I5*E5))))

Best regards,
Per

 

[Edward]

Thank You So Much!!!!

Hi

The formula should be entered as one line!

=IF(J5<10000,"Under
Min",IF(J5<25000,I5*B5,IF(J5<50000,I5*C5,IF(J5<100000,I5*D5,I5*E5))))

Best regards,
Per