I think you may be looking for this...

=IF(ABS(C1-C10)=5,"A","")

where, because you didn't say what to do if the difference was something
else, I output nothing if the difference is not 5.

--
Rick (MVP - Excel)


"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.