Forum Discussion

TARUNKANTI1964

Brass Contributor

Oct 10, 2022

EXCEL FORMULA

I HAVE AN EXCEL SHeet CONTAINS 5 COLUMNS. Column -A for DATE , Column - B for PRODUCT Opening , Column - C for PRODUCT Received , Column - D for PRODUCT Issue and Column - E for PRODUCT Closing. i...

Formulas and Functions

HansVogelaar

MVP

Oct 10, 2022

TARUNKANTI1964

In E3:

=IF(OR(C3:D3=""), "", SUM(B3,C3,-D3))

TARUNKANTI1964

Brass Contributor

Oct 11, 2022

Both Solutions Are Excellent Solutions!! Actually I Am at A Loss for Words to Express My Gratitude. Many Thanks to Every Member of the Community and I Would Like to Thank the Two of You Mr. Hans Vogelaar and Mr. Nothing_Left_to_Lose separately Also. In Fact, I am Indebted to This Community in Many Ways Regarding my EXCEL Solution.

Yours Faithfully
TARUNKANTI1964