Hello,
I am definitely not great with nested functions, so any help would be very appreciated. This is the formula I have thus far. There is an issue with it, but I am not skilled enough with it to see where it is at. =IF([@[Discount Y/N]]=N,0,[@[Tenure (Yrs)]]<5,=IF([@[Tenure (Yrs)]]<7,0.07,0.1))
Thanks,
Jason
Breaking down your formula you get this:
=IF([@[Discount Y/N]]=N
Then 0
Else [@[Tenure (Yrs)]]<5,=IF([@[Tenure (Yrs)]]<7,0.07,0.1))
The Else part is the part that doesn't make sense.
To sort your issue, what do you want to happen if Discount = Y?
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
Ok, it might be better if I list the steps I am to take.
a. If the value in Discount Y/N column is equal to N, the Discount column value should be 0.
b. If the value in the Discount Y/N column is equal to Y, the formula should check if the value in the Tenure (Yrs) column is less than 5.
c. If the value in Tenure (Yrs) column is less than 5, the Discount column value should be 0.07
d. Otherwise, the value of Discount column should be 0.1.
The "Y" is exactly where I am confused. Thanks for the quick reply too.
Ok. You were pretty close. Try this:Formula:
=IF([@[Discount Y/N]]=N,0,IF([@[Tenure (Yrs)]]<5,0.07,0.1))
I am getting the "#NAME?" error. I was getting that before as well.
DohTry this:
Formula:=IF([@[Discount Y/N]]="N",0,IF([@[Tenure (Yrs)]]<5,0.07,0.1))
If that doesn't fix it, make sure the Tenure (Yrs) data is in fact numbers not text.
Beautiful! That worked. I will study the structure of this so I can gain a somewhat talent in this. Thank you so much for your guidance!
Often with formulas for structured tables, I find it easier to manually type in the references so that they are easier to visualize. The "[@[Tenure (Yrs)]]" path then becomes a familiar-looking range A1:A20, or something
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have tried that formula. it tells me that I entered to many arguments for this function and it highlights 0.07.
This thread help me as well thanks to gak67
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks