Hi,
I'm trying to take .40 from one column, adding the sum from 2 others (sometimes 4) and that be reflected in the last...for some reason,
I keep getting a negative number, and it's not correct, lol
Currently I have:
=SUM(G2)*0.4+SUM(H2:I2)-SUM(N2) which is giving me a negative number...and not even the correct one at that
Any help would be appreciated
What numbers are in the cells indicated? What value are you expecting and what value are you getting?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
They are all positive numbers. It works fine until I try to subtract. G2 is $240.10 (then calculate .40 which would be $96.04) H is $24.50(add the whole) and I is $14.00 (add the whole). I then need to subtract N which is $215.00. I expect to see $134.50 (which is column O)
Oh, need to add F in also which is $117.47
240.1 x .4 = 96.04
96.04 +24.5+14=134.54
134.84 - 215 = -80.46
So I am not sure why you expect to get 134.50. Perhaps you need to explain further
Just saw your post.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Actually, it doesn't...but thank you for your help
Would you please mark the thread as closed? I was just informed the numbers I were given were incorrect, lol...and My thread tools is not appearing for me.
Thank you so much again
Thread closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks