Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
and if
I am trying to get ask if H2 is greater than or equal to 50 and I2 is letter
C please make true |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
and if
You don't need the if to return true/false as And returns True/False
=And(h2=5, I2="C") -- HTH... Jim Thomlinson "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
and if
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|