Dear All,
I need help to compare three col and show the value in column Result
Result Col contains formula as:
IF(E92>=F92, IF(D92<0,0,IF(D92>E92,E92-F92,D92-F92)),IF(D92<0,F92*-1,IF(E92<0, F92*-1,E92-F92)))
-------D------E------F---Result--Balance
90.....100......75......50.......25.......75
91......50......75......100......-25......50 <------- correct fig should be -50
92......75......50......100......-50......50 -------- in result column
93......75......100......50......25.......75 --------- rest all the figures
94......50......100......75......-25......50 -------- the figures in result col
95......100......50......75......-25......50 -------- are correct
Please help - thanks
I need help to compare three col and show the value in column Result
Result Col contains formula as:
IF(E92>=F92, IF(D92<0,0,IF(D92>E92,E92-F92,D92-F92)),IF(D92<0,F92*-1,IF(E92<0, F92*-1,E92-F92)))
-------D------E------F---Result--Balance
90.....100......75......50.......25.......75
91......50......75......100......-25......50 <------- correct fig should be -50
92......75......50......100......-50......50 -------- in result column
93......75......100......50......25.......75 --------- rest all the figures
94......50......100......75......-25......50 -------- the figures in result col
95......100......50......75......-25......50 -------- are correct
Please help - thanks