Previous Topic Next Topic

Excel 2007 Formula Help - if cell is empty...

Solved/Closed
Melissa - Nov 10, 2009 at 11:35 AM
 Melissa - Nov 11, 2009 at 01:29 PM
Hello,

Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3)

What is the proper formula to get the calculation to utilize J3 if there is a value and to use C3 if there is not ?

Any assistance is greatly appreciated. Thank you.
Related:

1 reply

Answer 1 / 1
aquarelle Posts 7120 Registration date Saturday April 7, 2007 Status Anonymous Last seen April 14, 2023 490
Nov 10, 2009 at 04:54 PM
Hello,

Try with this formula :
=IF(J3="",C3-SUM(L3:X3),J3-SUM(L3:X3))

Best regards
2
Melissa
Nov 11, 2009 at 01:29 PM
Thank you Aquarelle! The formula worked like a charm !
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
Formula to subtract one cell value from another.
autigers71 -
vcoolio -

1 response
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response