Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Excel 2007 Formula Help - if cell is empty... [Solved/Closed]

Report
-
 Melissa -
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.
See more

1 reply

Answer 1 / 1
Posts
7077
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
September 18, 2020
 498
Hello,

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

Best regards
Thank you
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2886 users have said thank you to us this month

Report

Thank you Aquarelle! The formula worked like a charm !
Ask a question