SIGN UP

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

Avatar Image
Elena_W | 02:37 Sun 18th Oct 2015 | Technology
6 Answers
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.

Answers

1 to 6 of 6rss feed

Best Answer

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

For more on marking an answer as the "Best Answer", please visit our FAQ.
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
thank you for your help!

1 to 6 of 6rss feed

Do you know the answer?

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

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.