div/0 and #num!
Posting the same request 3 times in 6 minutes won't get you a quicker
response!
Try this:
=IF(OR(ERROR.TYPE(A4)=2,ERROR.TYPE(A4)=6),B3,A4+3)
See ERROR.TYPE in Excel Help for an explanation.
--
Ian
--
"bastien86" wrote in message
...
Sorry i'm new to this board
i'd really like an if statemet that says =if(a4=(#num! OR
div/0!),=a3,a4+3)
|