Tue, 8 May 2007 15:29:03 -0700 from Poshsod.uk
:
HHHHHEEEELLPPPPP.
I am trying to compile a formulae to convert a a cell into a result with
differing results based upon certain criteria.
ie I have a table with name downwards: date sequence top horizontal and
hours worked (horizontal alongside names.
What I want is another table to look at CELL A:2 and if it is less than
VARIABLE 1: then show ANSWER 1:

=if(A2<V1, A1, ....)

if its greater than VARIABLE 1: then look at the greater of VARIABLE 1
and the less than or equal of VARIABLE 2 and if its between these then show
ANSWER 2:

I don't understand what you mean here.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/