Return Blank cell rather than "False" in If Then Statement, Formula

[gmduece]

Hello,

I'm trying to stamp date a field id another is occupied. =IF(A8>0,NOW())

if it is blank it displays False, what is the formula symbol for blank?

Thanks

 

[AliGW]

=if(a8>0,now(),"")

 

[Jonmo1]

Welcome to the board.

Every IF has 3 arguments
IF(Expression,Value_If_True,Value_If_False)

Only the Value_If_False argument is optional, and when it's omitted the formula will simply return FALSE if the Expression is False.

So you just need to tell it what to return "" instead of FALSE when the expression is False..
Try

=IF(A8>0,NOW(),"")

 

[gmduece]

Of Course, the empty space bracketed by quotes. I forgot, its been a while Thanks much

 

[gmduece]

How do I fire a macro from the formula: to wit

Sub NowFix()
'
' NowFix Macro
'

'
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub