Let's say i have a 0 in H14, 8 in H13. I know how to make H15 add the two to make 8 again, but for H12 i need it to be 2. 10-8=2. Is that possible to do? I have tried many variations with this and can't get it to work.
If it is possible, how would i incorporate it into this formula? =IF(M5>N5,M5-N5,IF(N5>M5,N5-M5,IF(M5=N5,0)))
Or is that possible?
Thanks guys, again!!! You are all the best!!!
maybe..
=10-ABS(H13-H14)
Life's a spreadsheet, Excel!
Say thanks, Click *
or :
=IF(H14=0,10-H13,your formula for H14<>0)
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Originally Posted by dredwolf
That got it dredwolf. Thank you again for your help!!! Works like a charm. I added my formula to the end just like you said. About to get this thing done i hope. Got a few more things to get figured out and finito.
Thank you so much!!! And all the others that have helped me out!!!
Thank you very much for the relpy and help Ace_XL. I didn't know how to incorporate it in with what i had. That's me still learning this stuff.
I do appreciate it very much!!!
You are very welcome
Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks