=if(a2>0,now())

[Trevor3007]

Hi

I currently use =IF(A2>0,NOW()), which is great when A2 meets the criteria, however when A2 does not meet the criteria, A2 displays False.

I would prefer that A2 was just blank if the criteria is not met rather than display False.

Does any know/have the solution ?

MTIA & KR
Trevor3007

 

[Joe4]

The IF formula has three arguments. The third, which is optional, is what to return when the condition if FALSE. If you leave it blank, it defaults to FALSE.
So try:

[COLOR=#333333]=IF(A2>0,NOW(),"")[/COLOR]

 

[Trevor3007]

The IF formula has three arguments. The third, which is optional, is what to return when the condition if FALSE. If you leave it blank, it defaults to FALSE.
So try:

[COLOR=#333333]=IF(A2>0,NOW(),"")[/COLOR]

Thanks Joe,

once again you have sorted for me & i have learnt too :]

Many thanks
Trevor3007

 

[Joe4]

You are welcome!