Need MSExcel 2007 Formula

Closed
ishfaq90 Posts 9 Registration date Wednesday July 17, 2013 Status Member Last seen January 28, 2015 - Dec 30, 2014 at 07:53 AM
vcoolio Posts 1410 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - Dec 31, 2014 at 03:46 AM
Hello, Masters of Excel.
I need formula like H5+I5+J5+K5+L5+M5+N5-O5=P5. I need H5 to N5 add & subrtact O5 in P5. Hope i have detailed this brief.
Thanking in anticipation.
Related:

1 response

vcoolio Posts 1410 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
Dec 30, 2014 at 09:01 AM
Hello Ishfaq90,

Perhaps this may do the job for you:-

=SUM(H5:N5)-O5

Enter the formula in cell P5.

Regards,
vcoolio.
0
ishfaq90 Posts 9 Registration date Wednesday July 17, 2013 Status Member Last seen January 28, 2015
Dec 30, 2014 at 09:56 AM
Thanx bro. Now need another, hope u could help. In column R5 i put =IMSUM(P5,Q5).I need the amount of R5 to auto enter in S5 not formula & then i need S5+R6 in S6. This will be in spreadsheet, i am trying to making a template.
Thanks in anticipation.
0
vcoolio Posts 1410 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262 > ishfaq90 Posts 9 Registration date Wednesday July 17, 2013 Status Member Last seen January 28, 2015
Dec 31, 2014 at 03:46 AM
Hello Ishfaq90,

Glad I could help.

Now, for your next query:-

If I have understood you correctly, then in cell S5, enter:-

=R5

and in cell S6 enter:-

=SUM(S5+R6)

I would be interested to know why you are using the IMSUM function. Are you adding complex numbers from P5 & Q5 in R5?

If so, I would like that other forum Contributors join this thread as complex number functions such as IMSUM (addition) or IMSUB (subtraction) don't come up that often on forums and for me it is still a very grey area (actually, it has been a grey area for me since High School!!!).

Kind regards,
vcoolio.
0