View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Noob McKnownowt Noob McKnownowt is offline
external usenet poster
 
Posts: 37
Default Complex decisions, maybe?

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.