IF formula for 3 possible conditions
I'm trying to setup a formula as follows:
If the value referenced is between 1 and 200, it will add 16 to itself; if
it is between 201-1000, it will multiply itself by 108%; if it is 1001 or
greater it will add 80 to itself.
I originally set it up as:
=IF(V7<201,V7+16)+IF(V7=201,1000,V7*108%)+IF(V710 00,V7+80)
but this formula only works for the middle condition (values between 201 and
1000).
I'm going crazy, what am I doing wrong?
Thanks in advance for any guidance.
|