Data Validation in =IF()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Is it possible to use Data Validation (ex: limiting to list) in the =IF() Functio

Regard
Sachin
 
Data in A2 needs to be exclusively from list i.e. A,B,C,D,E,
But only IF A1>=100
Orelse Value of A2 needs to be

Kindly hel

Regard
Sachin
 
Hi
try the following:
- insert the values A,B,C,... in a range of your spreadsheet and define
a name for this range (lets say 'list_1'). to do this goto the menu
'Insert - Name - Define'
- enter a zero in a cell and also define a name for this cell (lets say
'list_2')
- now select cell A2, goto the menu 'Data - validation', choose 'List
and enter the following formula as source:
=IF(A1>1000,list_1,list_2)

This will allow only entries depending on the value of cell A1. note:
This does not change the values in A2 automatically if you change A1.
For this you'll need a worksheet_event procedure
 
Back
Top