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.

Excel 2007 Formula Help - if cell is empty...
Save as pdf office 2007 - Download - Other
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Excel formula if cell contains text then return value in another cell ✓ - Excel Forum

1 response

Answer 1 / 1

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Nov 10, 2009 at 04:54 PM

Hello,

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

Best regards

Melissa
Nov 11, 2009 at 01:29 PM

Thank you Aquarelle! The formula worked like a charm !

Similar discussions

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

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

Calculation of positions in excel

How to use conditional format based on text?

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!