# Having Trouble With Excel 2013(Nested If Function) Can Anyone Help?

Elena_W | 02:37 Sun 18th Oct 2015 | Technology
I've tried doing this question for so long but I just can't get it. 6. In cell L4, enter a formula that uses a nested IF function and structured references to calculate the Discount Amount:
a. If the value in the Discount Y/N column is equal to N, the Discount Amount 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 4.
c. If the value in Tenure (Yrs) column is less than 4, the Discount Amount column value should be 0.10.
d. Otherwise, the value of Discount Amount column should be 0.15.

No best answer has yet been selected by Elena_W. Once a best answer has been selected, it will be shown here.

I need to see this written out so

If discount = no then amount = 0

else

If tenure < 4 then amount = 0.10 else 0.15

Is this what you read it as?
Assuming y/n is column A and contains either y or n and tenure is column B and amont is column L

=IF(A2="n",0, IF(B2
Ok something happend - only half my post appears!

Ignore the square brackets

[=IF(A2="n",0, IF(B2
3rd attempt - make the following 1 line - split here to try and get it to post!!!!

=IF(A2="n",0, IF

(B2<

4,0.10,0.15))

Test this and see if it works.

Looks good to this excel dabbler, as long as the row is 2.
Question Author