Example.xlsxHello, I am trying to come up a formula (that I would think is simple, but having a hard time figuring it out).
I want to calculate the difference between two cells, on separate sheets, only if the second number is great than the first number.
See attached.
Thank you!
Last edited by bhager; 11-06-2013 at 07:31 PM.
=IF(A1>Sheet1!A1,A1-Sheet1!A1,0)
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
I couldn't seem to get that one to work.
Maybe your example is missing data?
Which value are you subtracting from which? Are you using dates? Times?
It seemed to work fine for me.
need more infos.xlsx
Perhaps 1 of these?
=IF(B4>Sheet1!B4,B4-Sheet1!B4,"")
or
=MAX(B4-Sheet1!B4,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Using MAX to truncate subtractions? Genius.
Give that man a Klondike Bar.
LOL thanks, daffodil
Thank you, thank you!!
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, daffodil's suggestion would work too, you just needed to adjust the ranges
Last edited by FDibbins; 11-06-2013 at 08:03 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks