excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1498421%22%20slang%3D%22en-US%22%3Eexcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498421%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20I%20have%20an%20Excel%20problem%3A%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20do%20a%20What%20if%20problem%3A%26nbsp%3B%3DIF(H2%20cell%20is%20empty%20then%20(SUM(H2-G2)%3C%2FP%3E%3CP%3EI%20keep%20getting%20error%20notice%2C%20how%20do%20I%20fix%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1498421%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498526%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498526%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F714271%22%20target%3D%22_blank%22%3E%40kristineadennettlmC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20you%20are%20saying%20would%20be%20translated%20into%20this...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(H2%3D%22%22%2CH2-G2%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20if%20H2%20is%20blank%20or%20empty%2C%20do%20you%20still%20want%20to%20subtract%20G2%20from%20H2.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20above%20IF%20formula%20H2%3D%22%22%20is%20the%20logical%20condition%20and%20if%20it%20is%20true%2C%20H2-G2%20would%20be%20evaluated%20else%20it%20will%20return%20a%20null%20string%20in%20the%20formula%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETweak%20it%20as%20per%20your%20requirement.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

HI I have an Excel problem:

I am trying to do a What if problem: =IF(H2 cell is empty then (SUM(H2-G2)

I keep getting error notice, how do I fix this

1 Reply
Highlighted

@kristineadennettlmC 

What you are saying would be translated into this...

 

=IF(H2="",H2-G2,"")

 

But if H2 is blank or empty, do you still want to subtract G2 from H2.

 

In the above IF formula H2="" is the logical condition and if it is true, H2-G2 would be evaluated else it will return a null string in the formula cell.

 

Tweak it as per your requirement.