Hey Forum,
I am trying to get this spread sheet to show blank in columns G, H, I, J when there is no data entered in column C. I can get it to show blank but that’s about it lol.
This is the formula I came up with for G16. It accepts it and blanks out the box, but it stays blank once data is entered… don’t know what I am doing wrong, but the few things I tried caused a refusal of the formula. Once I have the frame work I can modify it for the other columns.
=IF(AND(C16<>"",),D16+E16+F16, "")
Thanks for your help!
Sample for Forum.xlsx
Bookmarks