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/
------------------------------------------------
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/
------------------------------------------------