Forum Discussion
AussieMick
Apr 22, 2023Copper Contributor
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 ...
- Apr 22, 2023
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.
OliverScheurich
Apr 22, 2023Gold Contributor
- AussieMickApr 22, 2023Copper Contributor
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.