Thread: and if
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default and if

Try this formula

=IF(AND(H2=50,I2="C"),"True","False")

"dee" wrote:

I am trying to get ask if H2 is greater than or equal to 50 and I2 is letter
C please make true