Simple (I bet) Newbie question...
 

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

Simple (I bet) Newbie question...
 

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<100 000,I5*D5,I5*E5))))

Best regards,
Per

"Edward" skrev i meddelelsen
...
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!!

Simple (I bet) Newbie question...
 

Thank You So Much!!!!






"Per Jessen" wrote in message
...
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<100 000,I5*D5,I5*E5))))

Best regards,
Per

"Edward" skrev i meddelelsen
...
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!!