I have a fixed value, at the end of a row within a table, let us say 9,000. I want this value of 9,000 to be dependent on entering yes or no in the three cells (in the same row as the 9,000 value) that precede the value of 9,000.
For example: if YES to question 1, then multiply 9,000 by .05, call this new value x if NO to question 1, then multiply 9,000 by 1. call this new value x if YES to question 2, then multiply x by .1, call this new value x_2 if NO to question 2, then multiply x by 1, call this new value x_2 if YES to question 3, then multiply x_2 by .075, call this new value x_3 if NO to question 3, then multiply x_2 by 1, call this new value x_3
I tried using the following if statement:
Let us say cell D1=9,000
=IF(A1="YES",D1*.05,IF(A1="NO",D1,IF(A2="YES",D1*.1,IF(A2="NO",D1,IF(A3="YES",D1*.075,IF(A3="NO",D1,""))))))
My problem is once an answer of YES is entered, the value of 9,000 changes to a new value. Once another YES is entered, the value of 9,000 is again changed. However, I want the new value obtained from the first YES to be the value that gets affected by the second and/or third YES.
Thank you
Aucun commentaire:
Enregistrer un commentaire