View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
 
Posts: 661
Default IF & AND function

Hi,
Can any one help with a formula that does the following:

If A2 = A1 then B2 should = B1. If it does, then indicate OK otherwise
indicate not OK. The formula should also cope with A3 not equaling A2, where
it doesn't matter that B3 does not equal B2.

I hope this make sense.

Thanks for taking the time to look at my problem, your help is much
appreciated.

Paul