Go Back   Computer Forums > General Computing > Programming
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 04-28-2010, 03:18 AM   #1
In Runtime
Join Date: Jan 2010
Posts: 320
Default Quick Excel 'IF' Query

Hi all, a quick query im having withing excel, cant think of what to put.

Basically, the whole spreadsheet is completed and filled with info, now doing stats page.

I have a field (Column D row 3) that is drop down list. I have another field (E3) that is dependant on whatever is selected in D3, via an IF (which is what im stuck on atm)

Heres the basic code (written logically) that i want it to do, with a rough example.


D3 = 'Week'
THEN Allow user to enter a xx/xx/xxxx format into E3


D3 = 'Month'
Produce a drop down lists of the months in E3

etc etc

(Im then gonna run other IF'S and queries off the resulting data in E3, which will have been entered / selected by the user, and collected form various worksheets)

Shouldnt be too hard as D3 is a list, and will allways be one of 4-5 constants.

Etc, etc, I assumed I would be using a nested if.. I am pretty fluent in excel. just havent done this sort of 'multiple format' formula before. Anyone got the answer / or help / or point me to some direct reading on this specific area (most reading just talks about generalistic IF's etc)

Thanks in advance.

(if you need anything else as it might not be clear gimme a shout)

EDIT: Anyone ideas? or is it a case of VB coding?
Luke_Uk_Baggy is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 02:00 AM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2016, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0