Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to create a formula wich contains an if clause and a validaiton (list).
A1= will be "member" or "non member" (will be selcted from a list: ok) A2= 0.30 is A1="non member" and 1.0 A1="member" (if clause: ok) A3= amount will be entered (manually) A4= if A2="non member" then will ask for "Yes" or "No" (as validation) and if A2="member" will return as "Recorded" Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |