View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default Complex formula assistance please.


HI

In my helper column in K2 , I'm trying to construct a formula which
combines and satisfies these arguments:

If D2 is larger than 25 and J2 equals 1 or 11 , then put 5 , otherwise
put J2.
If D2 is larger than 25 and J2 equals 2 , then put 6 , otherwise put J2.


I've been struggling with syntax. Can anyone advise?


Grateful for any help.



Best Wishes