How shoudl I nest this formula

[bunnyfrostr]

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.


So far i have
=IF([@[Discount Y/N]]="N","0") that returned correct
I wasn't to sure on how to create a formula to check?

[6StringJazzer]

Looks like you're using a table. Try this:

Please Login or Register  to view this content.

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.