If function meeting criteria from two different cells and return a true or false

acapria

New Member
Joined
Sep 18, 2014
Messages
5
I cant seem to get this formula to work!

I need to check if

A1 is>26000 (greater than 26000)
and
B1 is = n (B1 is equal to "N")
Then
return value true in cell C1.

thank you!
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

bbott

Well-known Member
Joined
Feb 5, 2010
Messages
2,350
Welcome to the board. Try this in C1:

=AND(A1 > 26000, B1 = "N")
 

acapria

New Member
Joined
Sep 18, 2014
Messages
5
It returns a false value to every single one no matter what the value is in A1 and B1. I would like it to return the value only if its true. It seems simple enough but I have been banging my head on my desk with this one
 
Last edited:

acapria

New Member
Joined
Sep 18, 2014
Messages
5

ADVERTISEMENT

No, that didn't work either. It didn't return any values.
 

acapria

New Member
Joined
Sep 18, 2014
Messages
5
OK! Out of frustration, I closed out my spreadsheet, reopened it, and tried again... It worked!!!! Thank you soooo much!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,550
Messages
5,529,472
Members
409,884
Latest member
Msinmath
Top