Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Multiple conditions in a formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Help for a formula using two conditions | Excel Worksheet Functions |