IIf not working as expected

  • Thread starter Thread starter DEVOURU
  • Start date Start date
D

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
 
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
 
Back
Top