![]() |
#1
|
|||
|
|||
![]() For some reason, I can't figure out why this isn't working. Column is all currency. I need G2 to eventually get to $0 when I put in my amounts in G10 to G? I have tried using positive and negative numbers. How I think my formula should look: =600-(G10+G100) Keep getting error. Or =600-(G10:G100) gets error too. Also have tried =G10-(G10:G100) Last edited by Pecoflyer; 10-04-2016 at 11:28 PM. Reason: Removed link |
#2
|
||||
|
||||
![]()
Hi
as external links are potentially unsafe and not accessible to all members, I removed the one you posted. Could you please post a sample sheet ( no pics pse) showing your data and expected results? Thanks
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
Maybe:
=600-SUM(G10:G100) =600 - (G10:G100) doesn't give any result. However: =600-(G10+G100) should give a result if you have numbers in G10 and G100. |
#4
|
|||
|
|||
![]()
So this one works
=600-SUM(G10:G100) Thank you so much!!! |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Best presentation gear on a budget... | Akc123 | PowerPoint | 0 | 09-01-2015 11:41 PM |
![]() |
ThegoLopez | Excel | 2 | 01-05-2015 02:59 PM |
![]() |
Baddim | Project | 9 | 10-30-2014 03:06 AM |
![]() |
ttorneby | Project | 2 | 06-03-2010 04:52 PM |
Income/Budget Calendar? | Guinea | Excel | 4 | 03-11-2010 09:11 PM |