Excel formula in Access

gpbuckley

Gerry
Local time
Today, 23:12
Joined
Apr 8, 2010
Messages
16
Hi: I am relatively new to access and need to design a form. Have layout complete but now need to bring in a formula currently used in excel. Basically the formula will return a value under certain given criteria. Formula states:
=IF(B4<8,5,IF(B4<50,8,IF(B4<90,13,IF(B4<150,20,32))))

Used for determing sample sizes based on batch size. We designing a datavbse that will be as user frindly as possible and automatically retuirn info to the person using.

Can someone out there advise how to bring this formula into the access form?

Thanks a million.
 
in a query? try switch or nested iif's

the equivalent to if in access is iif (immediate if), and this nests in a similar way

personally i alsways try to avoid nested iif - and use functions instead - as
a) they are re-usable and
b) easier to understand/de-bug
 
Thanks for the quick response and I will give it a shot.
Cheers
 

Users who are viewing this thread

Back
Top Bottom