Problem adding column of numbers derived from IIf() expression

  • Thread starter Thread starter John House via AccessMonster.com
  • Start date Start date
J

John House via AccessMonster.com

I am trying to add a column of 5 numbers that were generated using the IIf()
expression. Example: =IIf([Fundraising]="2","50.00","0.00"). The column of
numbers generated could be for example 50.00, 20.00, 0.00, 5.00, 3.50

Using =[Number1]+[Number]+[Number3]+[Number4]+[Number5], the sum should be
78.50 but I end up with 50.0020.000.005.003.50. It apprears as it's
treating the numbers as text rather than numerals.

Can you help?? Thanks in advance - John
 
Thank you very much for your assistance however your suggestion did not
solve the problem.
 
I spoke too soon. By using =Val([Number1])+Val([Number2])+ etc. I was able
to get it to work.

Thank you very much - John
 
Back
Top