HELP ME!!!!!

[Guest]

I need to find the cheapest in a range of data and then display the cheapest
as a name (text), using Excel.

So if I had

Dog £50
Cat £67
Goldfish £20

CHEAPEST: Goldfish

I would also like to know how to do multiple If statements so that if I want
to on another sheet set it up so that one cell contained

If A1 = Goldfish this cell is £10 a month
If its dog this cell = £20 a month

etc.

Cheers,

 

[Guest]

This is an Access database discussion list. Your question should be posted to
an Excel list.

 

[BruceM]

You should ask this question in an Excel newsgroup. The Microsoft web site
may have misdirected you to this group, which is for Microsoft Access, a
relational database program.