View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Roger Bell Roger Bell is offline
external usenet poster
 
Posts: 7
Default Using "If" combined with "AND" statements

I am trying to enter a formula as below, but it is not accepted.

=IF(G30 'AND' g3<251,G3*1.2,0)

Can anyone help with where I am going wrong. With Thanks.