IF funcitons

G

Guest

Is there any way to perform more than seven IF functions
in one cell? If not, do you have a suggestion as to how I
can accomplish comparing 10 different scenerios in one
cell? Thank you.
 
F

Frank Kabel

Hi
no way using more than 7 nested functions but probably using a lookup
table and VLOOKUP could be an alternative. You may provide some more
details what you're trying to achieve. This way it would be much easier
to give you a specific answer
 
G

Guest

Actually, I may be trying to do something that is
impossible, but I'm not giving up. The formula below
works, however there are ten pages rather than 8, and
since I cannot put any more than 7 If functions, I find
myself in a dilemma. Thank you for your initial reply.
The formula is as follows:

=IF(M8="( )","Page 1 of 1",IF(W8="( )","Page 1 of
2",IF(AG8="( )","Page 1 of 3",IF(AQ8="( )","Page 1
of 4",IF(BA8="( )","Page 1 of 5",IF
(BK8="( )","Page 1 of 6",IF(BU8="( )","Page 1 of
7",IF(CE8="( )","Page 1 of 8"))))))))
 
G

Guest

Hello Frank,

When I put that formula in, I get #VALUE, didn't work.
Thank you for your patience.
 
F

Frank Kabel

Hi
you received a #VALUE and not a #NA error?. I just tried the formula
again on my own worksheet and it works if there's an entry in row 8
which matches to the lookup criteria
If you like you can email me your workbook and I'll have a look at it
email: frank[dot]kabel[at]freenet[dot]de
 
G

Guest

Thank you sir. I e-mailed it to you with a subject of "IF
functions.
-----Original Message-----
Hi
you received a #VALUE and not a #NA error?. I just tried the formula
again on my own worksheet and it works if there's an entry in row 8
which matches to the lookup criteria
If you like you can email me your workbook and I'll have a look at it
email: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

Hello Frank,

When I put that formula in, I get #VALUE, didn't work.
Thank you for your patience. 1
of
Click to expand...

.
Click to expand...
 
F

Frank Kabel

Hi
try the following formula as array formula 8entered with
CTRL+SHIFT+ENTER)
="Page 1 of " &
((MIN(IF((8:8="( )")*(MID(COLUMN(8:8)-3,10)=0),COLUMN(8:8)))-3)/10,
"0")

I also send you this per private email


--
Regards
Frank Kabel
Frankfurt, Germany


Thank you sir. I e-mailed it to you with a subject of "IF
functions.
-----Original Message-----
Hi
you received a #VALUE and not a #NA error?. I just tried the formula
again on my own worksheet and it works if there's an entry in row 8
which matches to the lookup criteria
If you like you can email me your workbook and I'll have a look at it
email: frank[dot]kabel[at]freenet[dot]de

--
Regards
Frank Kabel
Frankfurt, Germany

Hello Frank,

When I put that formula in, I get #VALUE, didn't work.
Thank you for your patience.
-----Original Message-----
Hi
try the following
="Page 1 of " & (MATCH("( )",8:8,0)-3)/10

--
Regards
Frank Kabel
Frankfurt, Germany

Actually, I may be trying to do something that is
impossible, but I'm not giving up. The formula below
works, however there are ten pages rather than 8, and
since I cannot put any more than 7 If functions, I find
myself in a dilemma. Thank you for your initial reply.
The formula is as follows:

=IF(M8="( )","Page 1 of 1",IF(W8="( )","Page 1 of
2",IF(AG8="( )","Page 1 of 3",IF
(AQ8="( )","Page 1
of 4",IF(BA8="( )","Page 1 of 5",IF
(BK8="( )","Page 1 of 6",IF(BU8="( )","Page 1 of
7",IF(CE8="( )","Page 1 of 8"))))))))
-----Original Message-----
Hi
no way using more than 7 nested functions but probably using a
lookup table and VLOOKUP could be an alternative. You may
provide some more details what you're trying to achieve. This
way it would be much easier to give you a specific answer

--
Regards
Frank Kabel
Frankfurt, Germany

Is there any way to perform more than seven IF functions
in one cell? If not, do you have a suggestion as to how I
can accomplish comparing 10 different scenerios in one
cell? Thank you.

.


.
Click to expand...

.
Click to expand...
Click to expand...
 
Top