View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default if and or functions

=IF(AND(A17="horiz curve",C17=90),C10,IF(AND(A17="horiz curve",C17=45),C11,""))

--
Gary''s Student - gsnu201001


"Darryl" wrote:

If A17 = horiz curve and C17 = 90 then answer should return what is in C10,
but if A17 = horiz curve and C17 = 45 then answer should return = C11

how do I write a formula for this?

Darryl