It happens to all of us!

--
Kind regards,

Niek Otten

"Neil M" wrote in message ...
| This ione of those moments when you read the answer and then get the guy next
| to you to slap you. I didn't even see it when I was typing the question!
|
| DUHHHHHHHHHHHHH!!!
|
| Thank You Niek
|
| "Niek Otten" wrote:
|
| Hi Neil,
|
| =IF(ISERROR(A4/A5),"",(A4/A5))
|
| --
| Kind regards,
|
| Niek Otten
|
|
| "Neil M" wrote in message ...
| | This should be an easy one for me, but I'll be darned if I can figure it out.
| |
| | I have 6 cells involved in one final answer.
| |
| | A1 = (varies)
| | A2 = (varies)
| | A3 = (varies)
| | A4 = A1 * A3
| | A5 = varies
| | A6 = A4/A5
| |
| | I keep getting the #DIV/0 error in A6
| |
| | This is what I tried and it keeps giving me a circular reference message:
| |
| | =IF(ISERROR(A6),"",(A4/A5))
| |
| | Please Help!
| | Neil
| |
| |
|
|
|