Using IF in query builder

[Albert]

Hello I have an excel formula

=IF(D2<=100,44, ROUNDUP((D2/50),0)*22)

that I wish to use in a query using [WordCount] in place of D2 giving me a number as the result


Using the IIF function
IIf([WordCount]<=100,44,(Round(0) [WordCount]/50*22))

I cant get the expression right using the expression builder, can some one assist me please
Albert

[pbaldy]

Is this what you meant?

IIf([WordCount]<=100,44,Round([WordCount]/50*22,0))

[Albert]

Perfect thanks its works just as I wanted to
thyats helped me out a lot
thanks A

[pbaldy]

No problem. If you end up needing a round up, Allen has some ideas:

http://allenbrowne.com/round.html

[Albert]

sorry your answer does work but not as I wanted
I want to round up the (WordCount divided by 50) to the next full interger and then multiply that number by 22

I still cant get the bracket in the right place
thanks
A

[pbaldy]

Did you review Allen's method?