Thread
:
IF function says too many nested
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
IF function says too many nested
Hi,
Am Mon, 30 Dec 2013 07:11:40 -0800 (PST) schrieb
:
=IF(B510,"Too many Longitudinal Bays",IF(B116,"Lateral Too Big",INDEX(LateralSupportNames,IF(B5=10,8,IF(B5=9, 7,IF(B5=8,6,IF(B5=7,5,IF(B5=6,4))))),IF(B11<=4,2,I F(B11<=6,3,IF(B116,"Lateral too big",#VALUE!))))))
if i add another IF funciton it return error "you've entered too many arguments for this function"
I am trying to go from 10 bays in B5 down to 3 bays and only can get to 6 then i have the error.
you can summarize the IF-statements. Here for B5 (for B11 and/or others
you can enlarge the formula):
=IF(B510,"Too many Longitudinal Bays",IF(B116,"Lateral Too Big",IF(AND(B5<=10,B5=3),INDEX(LateralSupportName s,B5-2),"")))
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch