First question, Do you have animals and the price in different cells (anmials
in column A prices in column B) or are they in one cell as text?

"Johnson" wrote:

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,
--
I don''t know what I''m doing on excel! Please HElp!