Hello to all.
I am running into an issue trying to write a nested formula. The formula consists of 3 parts. I can get it to work properly with 2, but when I attempt to add the last part it fails.
Here is what I need...
If A1 > 100 then A1*1.15 or else A1*1.18
If A1 < 50 then A1*1.20
OR...
$0-$49 Add 20%
$50-$99 Add 18%
$100 & Up Add 15%
This part works... =IF(A1>100,A1*1.15,A1*1.18)
I thought this would work, but it doesn't... =IF(A1>100,A1*1.15,A1*1.18),IF(A1<50,A1*1.2) *I get a return of #VALUE
I then tried... =IF(A1>100,A1*1.15,A1*1.18,IF(A1<50,A1*1.2)) *I get "Too Many Arguments".
Can anyone help?
Bookmarks