Nested formulas and combo box

[Richard]

Hello Everyone,
Could anyone assist me with answers to these problems.

1. Below is my formula which is copied down 10 rows. I
wish to add another nested formula to it but it exceeds
the 7 nested limit. Can anyone suggest how I can
incorporate this additional formula.
This is the formula I wish to add .. =if(and
(B3<>"",C3=""),"Outside Quote"&" "&"@ $"&W7

This is my existing formula:-
=IF(C3="s","Screen,"&" No "&A3,IF(C3="h","Returned",IF(AND
(C3<>"",C3>-9,C3<=0),"Partial "&" "&" "&100-FIXED(D3*100,2)
*-1&"%",IF(AND(C3<>"",C3>0,C3<=9),"Plus"&" "&" "&FIXED
(D3*100,2)&"%",IF(AND(A3<>"",C3<>"",E3<>""),"",IF(AND
(C3="",A3<>""),"Expensive"&" "&"@ $"&W3,IF(AND
(A3<>"",C3="d"),"Eliminated"&" "&"@ $"&W3,"")))))))

2. My spreadsheet is very large, about 1.23Mb and does not
alter much in size even though I have deleted many rows.
The last row is 260. I also have a lookup table that
extends for 100 rows by 2 columns below my main
application.
Is it better to reposition this lookup range beside my
main application on the spreadsheet or beside it. The s/s
is mainly formulas. How can I reduce the size of my sheet
or regain wasted space.

3. And lastly. I have four macro's available for the user
to select various options. Can I use a combo box to list
these options and then allow the user to select the
desired one. If so how do I link them so that the macros
run from within the combo box.

Thankyou for any help or guidance.

Regards,
Richard

 

[pancho]

Only have answer to your nesting problem, please try this:

=IF(C3="",IF(A3<>"","Expensive"&" "&"@ $"&W3,IF
(B3<>"","Outside Quote"&" "&"@ $"&W7,"")),IF
(C3="s","Screen,"&" No "&A3,IF(C3="h","Returned",IF(AND
(A3<>"",C3="d"),"Eliminated"&" "&"@ $"&W3,IF(AND
(C3<>"",C3>-9,C3<=0),"Partial "&" "&" "&100-FIXED
(D3*100,2)*-1&"%",IF(AND
(C3<>"",C3>0,C3<=9),"Plus"&" "&" "&FIXED(D3*100,2)&"%","")
)))))

In order that you dont waste your nestings, instead you
use them in a better way

Sincerely

Francisco Mariscal

fcomariscal at hotmail dot com