IF formula comparing values in 2 cells

[JPWRana]

I have 2 columns worth of data.

Column A is always supposed to have a larger value than Column B.
If Column B has a value larger than what's in Column A (same row), then this is wrong.

NOTE: Sometimes Column B will be blank, and that is ok.


How do I say (via formula), IF B1 has a larger value than A1, then in C1 put in "Not OK". If it's ok, put in GOOD.
When I drag this formula down to the other rows, the cells in column B that are blank will throw the error that Column B is larger than column A.
How do I fix this?

[AlKey]

Try this
Enter in C1 and copy down

Please Login or Register  to view this content.

[JPWRana]

Its almost there.

When I have blanks in B1, it will give me the Not Ok answer.
Whenever I have blanks in B1, that is ok.

[AlKey]

I don't see this happening. When B1 is blank and A1 contains value formula returns Blank; IF A1 is blank and B1 has value the formula returns Blank.

v	A	B	C	D
1	11			<--Blank
2	12	13	Not Ok
3	14	5	Good
4		15		<--Blank

[JPWRana]

Never mind... it works now.

[JPWRana]

Thanks you Alkey. I will post as solved.