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

More info required. Lay out the data.

--
HTH

Bob Phillips

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

"Johnson" wrote in message
...
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

Plus. How about a meaningful subject line.

--
Don Guillett
SalesAid Software

"Bob Phillips" wrote in message
...
More info required. Lay out the data.

--
HTH

Bob Phillips

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

"Johnson" wrote in message
...
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

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)

--
Regards,
Fred


"Johnson" wrote in message
...
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