Hi Guys,
Hoping someone can help me with this formula.
In Cell S3 I would like the the sum of M3 - Q3, unless there is a value in P3, if there is a value in P3 then i would want the sum to be M3-P3 instead.
Sometimes there will be a value in the P column and some times there wont, but there will always be a value in the M column
If P3 was to be blank i need the sum to go back to the original M3 - Q3
Thanks in advancesheet.png
=IF(P3="", SUM(M3:Q3),SUM(M3:P3))
Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet.
A sample sheet would help here, and possibly will enable a quicker and more accurate solution for you.
The forum does allow for spreadsheets to be uploaded direct to the forum -
Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Here are the instructions, found at the top of the page again
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Sorry i should of uploaded a sheet and explained it better.
So, in the attached sheet:
in Cell E3 I would like the sum B3-D3 as cell C3 is blank, however, if there was a value in Cell C3 i would want E3 to return C3- D3.
So for example, the sum for E3 would need to be B3-D3 resulting in £32,591.62 but on the next line the return i need in E4 is C4-D4 because there is a value in C4 which should result in £15,993.15
Hope thats a bit clearer
Try this in E3 and copy down.
=IF(C3="",B3-D3,C3-D3)
the SUM() and then cell-cell was bit confusing
anyway
the formula still is valid - just different , as we are now sub tracking and not summing a range , and different cells
principle is the same
=IF(C3="",B3-D3,C3-D3)
Or try in E3 and copy down:Formula:
Please Login or Register to view this content.
Thanks guys works perfectly
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks