Forum Discussion
under, between, over
how to use formulas/functions in excel if answer requires additional functions? if answer is under 10 need to multiply by 1000 and multiply again using specified cell, if answer is between 10/12 ne...
Shouldn't the last one be "if answer is over 12"?
Let's say the input is in cell A1, and the multiplication factor in B1.
In another cell:
=A1*B1*IF(A1<10,1000,IF(A1<=12,2000,3000))
yes, does this help...how to functions;
if under 10000 multiply 1000 x A1,
if between 10000 - 12000 multiply 2000 x A1,
if over 12000 multiply 3000 x A1.
if under 10000 multiply 1000 x A1,
if between 10000 - 12000 multiply 2000 x A1,
if over 12000 multiply 3000 x A1.