Miltipule IF formula

K

Koreno

Is it possible to make a formula with multipul IF's?

My situation... Kep in mid these are not the actual cells in my
spreadsheet. LOL

If A1=F1 then display B1
If not, check if A1=F2. If yes then display B2
If not, check if A1=F3. If yes then display B3
So on and so on.

The formula will be quite long. 25 IF's I think.

Please Help.

Thank You.



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Vlookup to store formulas? 6
Creation of a formula 2
Naming non-contigent cells with vba 5
Prob an easy one: How do i copy a formula EXACTLY as it is 9
Adjusting formulas by copying across cells w/o changing the refere 6
Conditional Formula Based On A Check Box 1
Return column header within an array when a value is met 9
Adding a Number and Formula Text and Evaluating 1

Top