Need MSExcel 2007 Formula
Closed
ishfaq90
Posts
9
Registration date
Wednesday 17 July 2013
Status
Member
Last seen
28 January 2015
-
30 Dec 2014 à 07:53
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 31 Dec 2014 à 03:46
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 31 Dec 2014 à 03:46
Related:
- Need MSExcel 2007 Formula
- Save as pdf office 2007 - Download - Other
- Microsoft picture manager download 2007 - Download - Image viewing and management
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Grade formula in excel marksheet - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
30 Dec 2014 à 09:01
30 Dec 2014 à 09:01
Hello Ishfaq90,
Perhaps this may do the job for you:-
=SUM(H5:N5)-O5
Enter the formula in cell P5.
Regards,
vcoolio.
Perhaps this may do the job for you:-
=SUM(H5:N5)-O5
Enter the formula in cell P5.
Regards,
vcoolio.
30 Dec 2014 à 09:56
Thanks in anticipation.
31 Dec 2014 à 03:46
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.