how to use Ms Excel if()
 

Hi ...
dear friends i have a problem with using Ms Excel if() , i need to use it
for multiple choices but Ms Excel allow us to use it seven time. while i need
it to use hundreds of times.i need to use in worksheet not in VBA.

Use a lookup table, for instance Vlookup, put the criteria in one column and
the result in another

=IF(A1="","",VLOOKUP(A1,B1:C100,0))

where the criteria values would be in B1:B100 and their associated results
adjacent in C1:C100

--
Regards,

Peo Sjoblom


"reneabesmer" wrote in message
...
Hi ...
dear friends i have a problem with using Ms Excel if() , i need to use it
for multiple choices but Ms Excel allow us to use it seven time. while i
need
it to use hundreds of times.i need to use in worksheet not in VBA.

Describe the data and the required results.

--

HTH

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


"reneabesmer" wrote in message
...
Hi ...
dear friends i have a problem with using Ms Excel if() , i need to use it
for multiple choices but Ms Excel allow us to use it seven time. while i
need
it to use hundreds of times.i need to use in worksheet not in VBA.