View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Complex decisions, maybe?

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.