should be an AND command with A5-B5<0

=IF(AND(ISNUMBER(A5),ISNUMBER(B5),A5-B5<0),IF(ROUND(7/(A5-B5),5)0.5,A5,""),"")

it might be better if I edited myself a bit more thouroughly.


"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
Try
=IF(OR(ISNUMBER(A5),ISNUMBER(B5),A5-B5=0),IF(ROUND(7/(A5-B5),5)0.5,A5,""),"")

if I types it right, it should leave the target cell blank if there is not
a number in either A5 or B5, and will also prevent a "Divide by 0" error.

"Ted" wrote in message
...
Hi, I have just realised that the reason why its returning a 'DIV/0! is
because there wasn't an entry in one of the cells (in one of the A3-D3
cells). This raises a new problem, is there a way I can get it to ignor
cells
that have no numbers to be computed (e.g. if the data was A3-B3, A4-B4,
A5-B5, and A3-A4 and A5-B5 have data in, but A4-B4 has no values/data in.
I
would need it to ignor A4 and B4, and return a blank (as in completely
empty)
cell in the cell where the answer is then supposed to reside - any
suggestions??

also, working with Biff's earlier suggestion of:

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

this all works great (thanks Biff $;-) but the end cell causes a
problem -
the last part of ...,A5,""), for some reason alters the answer (from
6047799.858 to 36891.000).

I am only guessing that it is the end part thats altering things because
when I break the sum down to ROUND(7/A5-B5),0.5 it works fine, and if I
change the A5 to a cell reference where I have other data in it, it
displays
that data ok (throwing out any data that is 0.5 and returning a blank
cell
in its place). So, I assume that it may be either the order in which the
sums
are computed or the A5 part - I think its the A5 part myself, but don't
know
why it does it - have you any suggestions please??


Ted.

"Biff" wrote:

Hi!

If you need further follow-ups keep posting them to the same thread.
It's
easier to follow what has taken place.

Try this:

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

Biff

"Ted" wrote in message
...
I have two main steps that I am trying to make in to one, which a

=ROUND(7/(A5-B5),5)
here I want it to take divide 7 A5-B5 rounded to 5 decimal places

=IF(A50.5,A5,"")
here I want it to remove any answers from the above that equal 0.5 or
less
because its outside of the range I am looking at. That's why I have
added
the
A5,"" part - so to replace the answer with a blank(?)


I have tried many different combinations to get these two to add
together,
so I can run it al in one cell, rather than two sets as I currently
have.

Is this possible, and if so, how please??


Thanks for all earlier responses, and I am sorry for the poor
equations I
entered earlier, that didn't even make sense because I wrote them
wrong -
not
a good start!

Ted.