Nested formulas and combo box
 

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<"",C30,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

Nested formulas and combo box
 

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<"",C30,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



-----Original Message-----
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<"",C30,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

.