Thread: div/0 and #num!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian
 
Posts: n/a
Default 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)