Higher value in cell b Than in Cell A

[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

 

[Peo Sjoblom]

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))

 

[mikewild2000]

thanks works very well.
However i did not need the "*(ISNUMBER(C7))" Bit.

 

[Peo Sjoblom]

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

 

[Ken Wright]

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
----------------------------------------------------------------------------

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

 

[mikewild2000]

Ahh - nice, that has also cured another problem.

Cheers!

What does the "*" do

 

[Dave Peterson]

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.

 

[Peo Sjoblom]

For Americans that would be Belt & Suspenders <g>

--

Regards,

Peo Sjoblom

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
-------------------------------------------------------------------------- --