Excel won"t display currency format?

[Stephenosn]

I'm using the formula bellow for a cell that I have formatted to currency but will not show as such. I'm using excel 2010. Does anyone know how I can get excel to recognize this as currency?

Thanks in advance.

=IF(D3="Loader",E3*135,) &IF(D3="mini",E3*90,) &IF(D3=350,E3*185,) &IF(D3=190,E3*145,) &IF(D3=160,E3*135,) &IF(D3=150,E3*135,) &IF(D3="Excavator With Large Breaker",E3*335,) &IF(D3="Excavator With Small Breaker",E3*240,) &IF(D3="Five Axle Dump",E3*98,) &IF(D3="Four Axle Dump",E3*95,) &IF(D3="Dump With Pup",E3*110,) &IF(D3="Water Truck",E3*85,) &IF(D3="Truck",E3*60,) &IF(D3="Truck With Trailer",E3*65,) &IF(D3="Dump With Trailer",E3*98,) &IF(D3="Truck With Dump Trailer",E3*65,) &IF(D3="Skid Steer",E3*70,) &IF(D3="Big Plate",E3*125,) &IF(D3="Small Plate",E3*50,) &IF(D3="Jumping Jack",E3*50,) &IF(D3="D6",E3*150,) &IF(D3="Backhoe",E3*95,) &IF(D3="Labor",E3*35,) &IF(D3="Hubber",E3*70,) &IF(D3="Water Trailer",E3*85,) &IF(D3="Water Truck",E3*85,) &IF(D3="Small Roller",E3*35+300,)

 

[Stephenosn]

Nix that. I had a typo.

 

[Stephenosn]

Is there a smart way to copy this down my column without the "G1:H20" increasing?

 

[Jonmo1]

Use absolute referencing..

=E3*VLOOKUP(D3,'Summary'!G$1:H$20,2,FALSE)+(300*(D3="Small Roller))

 

[Stephenosn]

Sweet. Thanks again