Allow Zero or a greater then a cell value in data validation in excel 2019

[hrdpgajjar]

Hi all,
I have to enter data validation rule in a cell (i.e. Cell A1) that it allows value 0 (Zero) or number value greater then in cell B1. Data must be in decimal points.

The whole idea is i want cell A1 value not less then cell B1. But it can be zero (Cell A1= 0 or greater then B1)


help appreciated,


Thank you,

 

[Peter_SSs]

Welcome to the MrExcel board!

Does this custom formula for data validation do what you want?

=AND(OR(A1=0,A1>B1),ISNUMBER(A1))

 

[hrdpgajjar]

Welcome to the MrExcel board!

Does this custom formula for data validation do what you want?

=AND(OR(A1=0,A1>B1),ISNUMBER(A1))

Works like a charm.. Thanks for prompt reply... very happy

 

[Peter_SSs]

Works like a charm.. Thanks for prompt reply... very happy

You are welcome. Thanks for the follow-up.