I'm having a difficult time with finding aa formula that fits my criteria.
I want to take one cell (A1)and show whether that cell is equal to or greater than another cell (B5),if the cell(A1) is greater than or equal to the other cell(B5) whats the difference totaled in cell (C5). If cell (A1) is equal to (B5) it should equal 0. If A1 is greater than B5 show the difference
I'm not clear on your description - when you say "difference" do you mean you might show a negative or positive amount or always positive. If it's the former try this formula in C5
=A$1-B5
or if you always want a positive result try using ABS function, i.e.
=ABS(A$1-B5)
If that isn't what you want then please describe an example - what's in A1, what's in B5, what do you want the result to be etc......
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks