hi
I am trying to develop a formula which will work out a total but calculates a minus figure correctly to work out a variance total ...see below for example
qty 1150 qty req 630 carryover -600.5 variance
this is a table format
currently using
variance=qty-(qty req + carryover) this does not give the correct answer
any ideas guys
Regards
Bookmarks