At 12:17 01/09/2014 +0100, Michael Gyles wrote:
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.
That depends on what you mean by "blank"!
If your test is actually for B2 being *empty*, try:
=IF(B2="";"";B2-B1)
If you want to treat B2 as "blank" also if it contains a string of
one or more blank characters, try:
=IF(TRIM(B2)="";"";B2-B1)
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
