Hello all.
Here is the formula that I came up that is not giving me the desired result:
=IF(C7<51,IF(NOW()-C11>60,C7,IF(C7>51,IF(C13*0.25>C7,IF(NOW()-C11<365,C7)))))
What I am trying to do is reflect that if the value in C7 is less than 51 and if the date in column C11 is greater than 60 days from today's date, then reflect the value in C7 OR if the value in column C7 is greater than $51 and if the value in column C7 is less than 25% of the value of column C13 and the date in column C11 is greater than 365 days from today's date, then reflect the value in C7.
What I am getting now is that the only criteria being considered is that before OR above.
What is needed for my formula to take all of the criteria into consideration prior to providing a result?
Thanks for your help.
Here is the formula that I came up that is not giving me the desired result:
=IF(C7<51,IF(NOW()-C11>60,C7,IF(C7>51,IF(C13*0.25>C7,IF(NOW()-C11<365,C7)))))
What I am trying to do is reflect that if the value in C7 is less than 51 and if the date in column C11 is greater than 60 days from today's date, then reflect the value in C7 OR if the value in column C7 is greater than $51 and if the value in column C7 is less than 25% of the value of column C13 and the date in column C11 is greater than 365 days from today's date, then reflect the value in C7.
What I am getting now is that the only criteria being considered is that before OR above.
What is needed for my formula to take all of the criteria into consideration prior to providing a result?
Thanks for your help.