| 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 | |
|
|
Hybrid Mode
