Excel formula

Copper Contributor

Hello community, I have a table with several columns. I would like to use a function that in one cell does not let me put a smaller number than it is in another previous cell, in the same row. Can anyone help me with this formula? I tried this: '= IF (B <A, "ERROR", B), yes it doesn't work.

3 Replies

@Gabriel985 

=IF(B3<A3," ERROR",B3)

 

Is this what you are looking for?

@OliverScheurich 

 

Not realy. I want it to give me an error in that box when I enter a value, meaning not to let me enter it.

@Gabriel985 

=B3>A3

 

This data validation rule allows entries B3>A3 and rejects entries B3<A3.