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.
|