N
N E Body
Hi
I have a formula I use 5 times but I want to nest them into one formula but
I cannot get anywhere.
The formulas are
=IF(AND((C3<=F2),(D3>F2)),"on","off")
=IF(AND((C4<=F2),(D4>F2)),"on","off")
=IF(AND((C5<=F2),(D5>F2)),"on","off")
=IF(AND((C6<=F2),(D6>F2)),"on","off")
=IF(AND((C7<=F2),(D7>F2)),"on","off")
By calling the functions A, B,C etc a phonetic description would be
if A or B or C or D or E is true then put "on" otherwise put "off"
Can anyone nest this for me as I have spent a day and got nowhere.
TIA
Kenny
I have a formula I use 5 times but I want to nest them into one formula but
I cannot get anywhere.
The formulas are
=IF(AND((C3<=F2),(D3>F2)),"on","off")
=IF(AND((C4<=F2),(D4>F2)),"on","off")
=IF(AND((C5<=F2),(D5>F2)),"on","off")
=IF(AND((C6<=F2),(D6>F2)),"on","off")
=IF(AND((C7<=F2),(D7>F2)),"on","off")
By calling the functions A, B,C etc a phonetic description would be
if A or B or C or D or E is true then put "on" otherwise put "off"
Can anyone nest this for me as I have spent a day and got nowhere.
TIA
Kenny