Hi!

Try this:

=AND(ISNUMBER(B9),B10<=B9*1.5)

Uncheck Ignore blank

Biff

"account via OfficeKB.com" <u15495@uwe wrote in message
news:56eba90ca12c7@uwe...
I am having a problem with a formula: It says to do under data, validation,
and in settings under allow choose custom then in the formula box, this is
where the problems i need a formula then determines that the value in cell
b10 is less than or equal to 150% of the value in b9. Please help i have
tried everything.