Hi Gert, If(a1="";c1=b1*5;c1=a1*5)
If a1 is blank, c1 will be five times the contents of b1, otherwise c1 will be five times the contents of a1
tc Gert Blij wrote:
How can I create an IF statement that says: If a cell is blank (null (?)) do something else do something else. TIA Gert --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
