Thread
:
Formula Problem with IF (Negative and Positive Numbers)
View Single Post
#
2
pingtom
Junior Member
Posts: 2
You can mapping your problem into diagram below:
your formula is
=IF(L6-K6<0,(L6-K6)/(K6-J6),IF(L6-J6<1,(L6-K6)/(K6-J6),(L6-J6)/(K6-J6)))
where
L6 is Actual December 2011
K6 is Plan 2011
J6 is Actual 2010
diagram is
Reply With Quote
pingtom
View Public Profile
Send a private message to pingtom
Find all posts by pingtom