Drop Down Menu and Cell Control

alaska August 22, 2008 at 05:48:37 Pacific
Windows XP, -

Hi,
I wanted to ask if it is possible to do the following, bearing in mind I have no VB experience.
In Worksheet 1, Cell B63 I would like to create a drop down menu, with two options for the user to select - 0.05 and 0.01. I would like each selection to then control the formula in the cells C63:L63, for example;
Where 0.05 selected it computes for cell C63:
=IF(COUNTA(C4:C54)=0,"",IF('WORKSHEET4'!N55>'WORKSHEET4'!L55,"YES","NO")
then cell D63
=IF(COUNTA(C4:C54)=0,"",IF('WORKSHEET4'!AC55>'WORKSHEET4'!AA55,"YES","NO")
and so on
Then if 0.01 selected it would compute for Cell C63
=IF(COUNTA(C4:C54)=0,"",IF('WORKSHEET4'!N55>'WORKSHEET4'!K55,"YES","NO")
then cell D63
=IF(COUNTA(C4:C54)=0,"",IF('WORKSHEET4'!AC55>'WORKSHEET4'!Z55,"YES","NO")
and so on.
Appreciate any advice on this.
Thanks

Reply to alaska ↓

Google Ads

DerbyDad03 August 22, 2008 at 07:08:44 Pacific

Why not just add one more nest to your IF statement to check and see what value is in B63?
Something like:

=IF(B63=0.05,Your Formula for B63=.05,IF(B63=0.1,Your Formula for B63=.1,Your Formula for B63=Something Else))

Reply to DerbyDad03 ↓

alaska August 22, 2008 at 08:16:45 Pacific