HELP ME!!!!!

J

Johnson

I need to be able to find the cheapest out of a range of data and then
specify which is the cheapest as a name (text).

I also need to be able to use an if statement over 2 sheets?

Cheers,

M.Johnson
 
B

Bob Phillips

More info required. Lay out the data.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
F

Fred Smith

1. To determine the cheapest, you probably want the MIN function.

2. Where is the text to come from? The adjacent cell?

3. If statements, or any function, will happily cross two sheets. Just use the
sheet name in the formula, as in:

=if(test,Sheet1!A1,Sheet2!A1)
 
Top