Forum Discussion

AussieMick's avatar
AussieMick
Copper Contributor
Apr 22, 2023
Solved

I need blank cells

Hi all. I'm new to this group & still learning lots about Excel. I am working on a sheet where I have two separate cells with values contained within. These refer to stock amounts. The first is the ...
  • AussieMick's avatar
    AussieMick
    Apr 22, 2023

    OliverScheurich 

    Thank you for the help. your formula was almost on the money: =IF(J5>I5,"",SUM(J5-I5))

    All I needed to do to make it work was change the (=IF(J5>I5... to =IF(I5>J5

    Other than that, it is perfect!

    Thank you so much. I really appreciate the help.