View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default conditionals statements

I believe you posted this earlier in the forum! You need to explain yourself
more, simply saying "compute" is not a legitimate term for describing what
you want. You also tend to create sevearl run-ons in your logic, making it
unclear. You state that 6781 is less than 6781, which makes no sense. Also,
we have no idea what the 49+6=5550 has to do with anything. Is the text
embedded in the cells with numbers? If not, is it even important?

Why does the last line missing half the data??

Instead of repeatedly posting the same thing, try to give more detail.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"out0015" wrote:

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.