Problems adding formula together. Please Help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ted - 20 Nov 2005 02:15 GMT

Hi,

I am ultimately trying to incorporate these two:

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

=IF(A3>0.5,A3,"")

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

Ted.

Reply to this Message

Adam Kroger - 20 Nov 2005 02:29 GMT

Doesn't the math portion of =ROUND(7/(A3-A3),5) specifically 7/(A3-A3)
result in a "Divide by zero" regardless of the value of A3?

I'm not the sharpest knife in the drawer when it comes to Excell ,(I'm
looking for help on another matter) so there could be something somewhere
else in the formula that invalidates my observation, but I'd start by making
sure the math operation is actually what you want done.

Adam

> Hi,
>
[quoted text clipped - 8 lines]
>
> Ted.

Reply to this Message

Ted - 20 Nov 2005 02:40 GMT

Hi, sorry, I meant to write A3-B3 for all of it - its because its for cells
ZX and ZY etc, so I thought it might be simpler to use examples of single
alphabet. Otherwise, the formula is fine – except for me not being able to
attach the two. They work well alone etc, I just don’t know what order to
separate the sections and what abbreviations to use etc.

If anyone has any ideas..?

Thanks for you response though, its appreciated.

Ted.

> Doesn't the math portion of =ROUND(7/(A3-A3),5) specifically 7/(A3-A3)
> result in a "Divide by zero" regardless of the value of A3?
[quoted text clipped - 18 lines]
> >
> > Ted.

Reply to this Message

Ted - 20 Nov 2005 02:44 GMT

the two I am trying to connect to be one sum, should be:

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

=IF(<0.5"")

where "" means enter a blank cell

sorry for the previous version.

any ideas?

T.

> Doesn't the math portion of =ROUND(7/(A3-A3),5) specifically 7/(A3-A3)
> result in a "Divide by zero" regardless of the value of A3?
[quoted text clipped - 18 lines]
> >
> > Ted.

Reply to this Message

Barb Reinhardt - 20 Nov 2005 02:56 GMT

I assume you do the ROUND function if something is < 0.5. What might that
be, pray tell?

> the two I am trying to connect to be one sum, should be:
>
[quoted text clipped - 34 lines]
>> >
>> > Ted.

Reply to this Message

Biff - 20 Nov 2005 02:36 GMT

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

> Hi,
>
[quoted text clipped - 8 lines]
>
> Ted.

Reply to this Message