Ok, here is the Correct equation I am having trouble with. (fr
"Ted" wrote:
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.
|