arguments
i am trying to get a formula to increase the dollar amount per $100.00 and
have been able to get the first part. i am not sure how to get the $$$ to
increase since there are a number of arguments per category.
=IF(C3<=600,C3+6,IF(C3=600.01,C3+8,IF(C3=700.01, C3=12,IF(C3=800.01,C3+20))))
this formula will not recalculate over 700.00 and up...any suggestions?
clear explanations would be appreciated since i am new to the formula world.
the last formula i came up withfor a different project was pieced together
from several different spreadsheets.
|