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

Question

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

[Solved/Closed]

Report

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...
Excel calculate formula only if cell contains a number ✓ - Forum - Office Software
How to copy cells from one sheet to another in excel using formula - How-To - Excel
How To Copy Data from One Excel Sheet to Another Using a Formula - How-To - Excel
Position formula in excel 2007 ✓ - Forum - Office Software
Excel putting result of a formula in another cell - Forum - Excel

1 reply

Ask a question

aquarelle · Accepted Answer · 2009-11-10T16:54:25-0500

Answer 1 / 1

aquarelle

Posts: 7098
Registration date: Saturday April 7, 2007
Status: Moderator
Last seen: June 10, 2021

486
Nov 10, 2009 at 04:54 PM

Hello,

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

Best regards

Report

Melissa
Nov 11, 2009 at 01:29 PM

Thank you Aquarelle! The formula worked like a charm !

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

1 reply

Your reply

Subscribe To Our Newsletter!