I can't get it right - I am not sure what I am doing wrong.
If anyone could guide me to the right path - I will be very thankful.
Here is the problem that I am working on
A. The first test should test if the shipping option in cell b15 is blank, and if so, then cell c17 should be blank.
B. Then a nested IF should test if B15 is equal to shipping option in D40, and if So, then the value in E40 should be used. (value listed below)
C. Then a nested IF should test if B15 is equal to the shipping option in D41, and if so, then the value in E41 should be used, otherwise the value in E42 should be used. (value listed below)
Cell D40 value = Standard
Cell D41 Value = Express
Cell D42 value = Overnight
Cell E40 Value = $9.50
Cell E41 Value = $14.50
Cell E42 value = $18.50
If anyone could guide me to the right path - I will be very thankful.
Here is the problem that I am working on
A. The first test should test if the shipping option in cell b15 is blank, and if so, then cell c17 should be blank.
B. Then a nested IF should test if B15 is equal to shipping option in D40, and if So, then the value in E40 should be used. (value listed below)
C. Then a nested IF should test if B15 is equal to the shipping option in D41, and if so, then the value in E41 should be used, otherwise the value in E42 should be used. (value listed below)
Cell D40 value = Standard
Cell D41 Value = Express
Cell D42 value = Overnight
Cell E40 Value = $9.50
Cell E41 Value = $14.50
Cell E42 value = $18.50