How do I use an IF statement to pick between two lists?

S

Spatton17569

=IF(b6>0(first_list,second_list))

Doesn't work. I want to automatically use a list unless there's a value
entered in the field. If there is, I want to be forced to use the second
list.
 
B

Bob Phillips

Use a list to do what? It seems to me that you need to incorporate this
within a bigger formula.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top