J
Joker
I have this formula which works the way I want except when I double click the
formula, it does not show the colored border around the cells in the formula
so I can quickly drag the formula to change it when I need to. Is there
something I am doing wrong which would prevent excel from doing this? I have
an almost exact same formula (bottom) which does show me the colored borders.
Any help would be appreciated.
=IF($D2=13328000,IF($G2>1199.99,$J5-$J2,$J4-$J2),IF($D2=13328100,IF($G2>1199.99,$J5-$J2,$J4-$J2),IF($D2=13328200,IF($G2>1199.99,$J5-$J2,$J4-$J2),IF($D2=13280300,$J5-$J2,IF($D2=13288100,$J3-$J2,IF($D2=13280800,$J4-$J2,IF(($D2=13286500)*($D1=10051202),$J3-$J1,IF($D2=13286500,$J4-$J2,""))))))))
=IF($D2=13328000,$J3-$J2,IF($D2=13328100,$J3-$J2,IF($D2=13328200,$J3-$J2,IF($D2=13280300,$J3-$J2,IF($D2=13280800,$J3-$J2,IF(($D2=13286500)*($D1=10051202),$J1-$J2,IF($D2=13286500,$J3-$J2,"")))))))
formula, it does not show the colored border around the cells in the formula
so I can quickly drag the formula to change it when I need to. Is there
something I am doing wrong which would prevent excel from doing this? I have
an almost exact same formula (bottom) which does show me the colored borders.
Any help would be appreciated.
=IF($D2=13328000,IF($G2>1199.99,$J5-$J2,$J4-$J2),IF($D2=13328100,IF($G2>1199.99,$J5-$J2,$J4-$J2),IF($D2=13328200,IF($G2>1199.99,$J5-$J2,$J4-$J2),IF($D2=13280300,$J5-$J2,IF($D2=13288100,$J3-$J2,IF($D2=13280800,$J4-$J2,IF(($D2=13286500)*($D1=10051202),$J3-$J1,IF($D2=13286500,$J4-$J2,""))))))))
=IF($D2=13328000,$J3-$J2,IF($D2=13328100,$J3-$J2,IF($D2=13328200,$J3-$J2,IF($D2=13280300,$J3-$J2,IF($D2=13280800,$J3-$J2,IF(($D2=13286500)*($D1=10051202),$J1-$J2,IF($D2=13286500,$J3-$J2,"")))))))