View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cbgraphics cbgraphics is offline
external usenet poster
 
Posts: 4
Default 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.