Hi!
I am trying to build a if/and/or formula that i am having some trouble with.
Currently i have the below formula that works
=IF(CAPI?="no",FLOOR(((Annual_Constraint-H19)/(1+G18)),5000),IF(OR(CAPI?="yes",CAPI_YRs=1,CAPI_YRs=2,CAPI_YRs=3),0,FLOOR(((Annual_Constraint-H19)/(1+G18)),5000)))
CAPI?, Annual Constraint, CAPI_YRs are all named cells
I am trying to add another portion to the formula.
I've added named cells Prin_Delay? and Prin_Delay_Yrs and would like to incorporate that into my formula.
What will happen is, the cell will look at both Prin_Delay? and CAPI? and depending on what those are it will do something else.
ANyone have any advice or be willing to help me with this?
THANKS!
I am trying to build a if/and/or formula that i am having some trouble with.
Currently i have the below formula that works
=IF(CAPI?="no",FLOOR(((Annual_Constraint-H19)/(1+G18)),5000),IF(OR(CAPI?="yes",CAPI_YRs=1,CAPI_YRs=2,CAPI_YRs=3),0,FLOOR(((Annual_Constraint-H19)/(1+G18)),5000)))
CAPI?, Annual Constraint, CAPI_YRs are all named cells
I am trying to add another portion to the formula.
I've added named cells Prin_Delay? and Prin_Delay_Yrs and would like to incorporate that into my formula.
What will happen is, the cell will look at both Prin_Delay? and CAPI? and depending on what those are it will do something else.
ANyone have any advice or be willing to help me with this?
THANKS!