if command

S

Srinivas

How to use the same comand in access

=IF(CEILING(B224/1000,5)<25,25,IF(CEILING(B224/1000,5)<50,50,CEILING(B224/1000,5)))

Thanks
 
D

Douglas J. Steele

The equivalent of Excel's If statement is the IIf statement. However,
there's no Ceiling function in Access.
 
G

Guillermo_Lopez

The equivalent of Excel's If statement is the IIf statement. However,
there's no Ceiling function in Access.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)






- Show quoted text -
Click to expand...

For a ceiling function i usually do

fix(value+0.99999999)

- GL
 
Top