Higher value in cell b Than in Cell A

  • Thread starter Thread starter mikewild2000
  • Start date Start date
M

mikewild2000

The user inputs numeric data into cells c7 to j7. The values must b
higher than the value in cells c6 to j6.

IE:
The data is already present in c6 to J6.

C6 must be a higher value than C7
D6 must be a higher value than D7, etc, etc


is there a way to make this work
 
You could try

select C7:J7 with C7 as the active cell, do data>validation>allow custom and
in the formula box put

=(C7>C6)*(ISNUMBER(C7))
 
You never know, that part is just to prevent a text entry, if someone enters
for instance "a" it
won't stop them since text is "greater" than numbers. It is just an extra
precaution
 
Belt & Braces - Works for me every time!!! :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Peo Sjoblom said:
You never know, that part is just to prevent a text entry, if someone enters
for instance "a" it
won't stop them since text is "greater" than numbers. It is just an extra
precaution
Click to expand...
 
The * represents multiply and in this case, it means AND.

=(C7>C6)*(ISNUMBER(C7))
is a shorter way of writing:
=and((c7>c6),isnumber(c7))

Actually, Peo's formula will return 0 or 1. So maybe it's a shorter way of
writing:

=n(and((c7>c6),isnumber(c7)))

But in this case, you wouldn't need the n() bit.
 
For Americans that would be Belt & Suspenders <g>

--

Regards,

Peo Sjoblom

Ken Wright said:
Belt & Braces - Works for me every time!!! :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :-)
-------------------------------------------------------------------------- --
Click to expand...
 
Back
Top