Complex decisions, maybe?
Thanks for the help Bob, but not quite what i am after,
if C1 = 5
and
C10 = 10 or 0
then C1 is within 5 (more than or less than) of that number so return the
letter A
there is more that will need to go into the formula so it doesnt need to
return a false value at the min.
but the help is very much appreciated.
The Noob.
"Bob Phillips" wrote:
Do you mean
=IF(ABS(A1+B1-C10)5,"A",A1+B1)
--
__________________________________
HTH
Bob
"Noob McKnownowt" wrote in
message ...
hey guys,
got a quick question for any one able to answer :)
say i have a table with various SUM functions from C1 to C10 calculating
the
numbers in A1 and B1 down to A10 and B10
in cell C1 i have 2 and in C10 i have 7
if C1 is 5 more than or 5 less than the value of C10 then the value of
that
cell should have an "A" out put to it.
there are other conditions but hopefully if you can help me with this i
can
figure the rest out.
thanks for any assistance given.
The Noob.
|