IIf not working as expected

[DEVOURU]

IIf([MF]>35,([MF]/[ltimed])*5) works fine for value over 35.
IIf(([MF]>35,([MF]/[ltimed])*5),[MF]) will not show values under 35.

Hmmm, whatcha think?

-JS

 

[Guest]

Mistake in the brackets - should be

IIf([MF]>35,([MF]/[ltimed])*5,[MF]

I'm pretty sure you don't even need the middle brackets anyway

IIf([MF]>35,[MF]/[ltimed]*5,[MF]

Basi

----- DEVOURU wrote: ----

IIf([MF]>35,([MF]/[ltimed])*5) works fine for value over 35
IIf(([MF]>35,([MF]/[ltimed])*5),[MF]) will not show values under 35

Hmmm, whatcha think

-J