Hi I am trying to create a formula using the Logical IF function to show; In cell C2, IF cell B2 is blank show C2 as blank otherwise sum cell B2 minus B1.
but can't get the syntax right whatever I try. Can you assist? Thanks Mike Gyles
Hi I am trying to create a formula using the Logical IF function to show; In cell C2, IF cell B2 is blank show C2 as blank otherwise sum cell B2 minus B1.
but can't get the syntax right whatever I try. Can you assist? Thanks Mike Gyles