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...
HansVogelaar Thank you for your replies and help. I tried to modify to and received message "you've entered too many arguments for this function". You've been helpful because I had 3 different calculations, and you consolidated into 1! Allow me to be more specific and see if we can resolve.
the 3 calculations are all based on A1.
if A1 is under 10,000, multiply 1,000 by B1
if A1 is between 10,000 and 12,0000, multiply 2,000 by B1
if A1 is over12,000, multiply 3,000 by B1
I hope this makes more sense. Thank you for you help!
=IF(M20<10000, E20*1000, IF(M20=10000, M20<=12000, E20*2000), IF(M20>12000, 3000*E20)))
