Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >
MaryCG401Copper ContributorJan 03, 2023IF FormulaTrying 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.
mtarlerSilver ContributorJan 03, 2023try=IF(ISNUMBER(B4), B4-SUM(C4:J4), "")MaryCG401Copper Contributor to mtarlerJan 03, 2023Thank you SO MUCH!!
