View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
out0015 out0015 is offline
external usenet poster
 
Posts: 14
Default conditionals statements

A B C D
E F




3795 59 TH ST ELEMENTARY 28 5548 22
6781 6 TH AVE ELEMENTARY 49 5582 50 <
6781 6 TH AVE ELEMENTARY 6 6781 53 <
5548 92 ND ST ELEMENTARY 21 3795 28 =
5582 93 RD ST ELEMENTARY 60


Help: I need a formula to automatically compute column F. ie 5548 in column
D is greater than 5548 in coulumn A 2221. 6781 in column D is less than 6781
in column A 49+6= 5550.