View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Problems adding formula together. Please Help!

Hi!

=ROUND(7/(A3-A3),5)


That won't work. You're dividing by zero and will return a #DIV/0! error.

Perhaps you mean:

=ROUND(7/A3-A3,5)

And perhaps this:

=IF(ROUND(7/A3-A3,5)0.5,A3,"")

Biff

"Ted" wrote in message
...
Hi,

I am ultimately trying to incorporate these two:

=ROUND(7/(A3-A3),5)


=IF(A30.5,A3,"")

I cant get them to both run together though - has anyone any suggestions
please??

Ted.