ExcelBanter - and if

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - and if (https://www.excelbanter.com/excel-discussion-misc-queries/178331-if.html)

DEE

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

AKphidelt

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

Jim Thomlinson

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

Bob I

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

All times are GMT +1. The time now is 08:22 AM.