IF with AND

Hi All,
I have been working on a formula to return a value based on conditional input into specified cells. I have gone through tutorials and searched the forums but can’t work out whether it is possible to achieve what I am setting out to do through just a formula or whether it would have to be a VBA solution.

So here is a basic version of what I have currently:

Please Login or Register  to view this content.

So in column A I have a number of cells that will contain 0 or > 0. I would like the formula to step through the specified cells as shown above and the first 1 to contain > 0 returns its corresponding answer e.g

IF A1 > 0 Then return “Answer1”
ElseIF
IF A1 = 0 & A2>0 Then return “Answer2”
ElseIF
IF A1 = 0 & A2 = 0 & A3 >0 Then return “Answer3”


Any help on how to achieve this would be wonderful.

Many Thanks!

Is it just 3 cells? If not, how many?
What are the "Answer"s ?
Are they going to be residing in other cells somehwere? Which cells? Or will they be hard coded into the formula?

Can you post a sample book?
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thanks guys for the responces.
To Jonmo1:
There are just 3 cells.
The "Answers" are hard coded, calculations that would be run in that case being returned. What it actually is, is this:

Please Login or Register  to view this content.

Makes it rather messy to look at so subed "Answer"

I can't really post a sample book as its too full of senstive data. I could if you'd like mock something up. But it would only really contain a 0 in A1 etc.

Try

=IF(A1>0,Answer1,IF(A2>0,Answer2,IF(A3>0,Answer3,"")))

Thank you guys for all your answers!
bebo021999 yours worked really well, Thank you!
ConneXionLost yours returned a #Value error, which mine was returning too.
Thanks again guys!