Forum Discussion

TARUNKANTI1964's avatar
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
Nothing_Left_to_Lose's avatar
Nothing_Left_to_Lose
Brass Contributor
Oct 10, 2022

TARUNKANTI1964 

 

=IF(AND( ISBLANK(C3), ISBLANK(D3)),"", B3+C3-D3)

 '---

This version might be more informative...

=IF(AND( ISBLANK(C3), ISBLANK(D3)), B3, B3+C3-D3)

 

 

'---

Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

  • TARUNKANTI1964's avatar
    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

Resources