I have the following formulae in a spreadsheet:
=IF(AND(AX3="",AY3=""),"",IF(AND(OR(AX3="Clear",AX3="N/A"),AY3="Clear"),"Yes","No"))
=IF(AND(BA3="",BE3=""),"",IF(BA3="No","No",IF(AND(BA3="Yes",BE3="Clear"),"Yes",IF(AND(BA3="Yes",BE3="Fail"),"No",""))))
=IF(AV3="","",IF(BH3="",TODAY()-AV3,BH3-AV3))
=IF(A3="","",IF(BH3="","No","Yes"))
=IF(BH3="","",IF(BA3="No","",BH3+90))
Unfortunately, these need to go down appoximately 10,000 lines and when the rest of the data is in it can be fairly slow to navigate due to all the recalculating.
Can anyone suggest an easy way of optimising these formulas and cutting down on recalculation?
=IF(AND(AX3="",AY3=""),"",IF(AND(OR(AX3="Clear",AX3="N/A"),AY3="Clear"),"Yes","No"))
=IF(AND(BA3="",BE3=""),"",IF(BA3="No","No",IF(AND(BA3="Yes",BE3="Clear"),"Yes",IF(AND(BA3="Yes",BE3="Fail"),"No",""))))
=IF(AV3="","",IF(BH3="",TODAY()-AV3,BH3-AV3))
=IF(A3="","",IF(BH3="","No","Yes"))
=IF(BH3="","",IF(BA3="No","",BH3+90))
Unfortunately, these need to go down appoximately 10,000 lines and when the rest of the data is in it can be fairly slow to navigate due to all the recalculating.
Can anyone suggest an easy way of optimising these formulas and cutting down on recalculation?