Simple (I bet) Newbie question...

  • Thread starter Thread starter Edward
  • Start date Start date
E

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!!
 
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
 
Thank You So Much!!!!






Per Jessen said:
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
Click to expand...
 
Back
Top