Forum Discussion

MaryCG401's avatar
MaryCG401
Copper Contributor
Jan 03, 2023

IF Formula

Trying to get a IF formula to work.  If there is a number in B4 then I want to subtract  C4 through J4 but if there is not number in B4 then I want it to be blank.
excel
mtarler's avatar
mtarler
Silver Contributor
Jan 03, 2023

try
=IF(ISNUMBER(B4), B4-SUM(C4:J4), "")

  • MaryCG401's avatar
    MaryCG401
    Copper Contributor
    Jan 03, 2023
    Thank you SO MUCH!!

Resources