combining functions ??

[fflan513]

I want to ROUNDDOWN the following:

=IF(D2>=300,5,0)+(D2/25)+(E2*6)

I'm a complete Excel novice, please help.
How can I add rounddown to this? What';s the proper syntax?

 

[Jack in the UK]

Hi

Not to sure how you want to go or if this is what you want, but just in case you have issues combining teh fiunctios

=ROUNDDOWN(IF(D2>=300,5,0)+(D2/25)+(E2*6),2)

Jack

 

[fflan513]

That's it Jack; thanks for you prompt response.

 

[Jack in the UK]

Good news

I dedicate my above post the Fire Fighter in the UK soon to withdraw work and strike, seems even the so called [now fasionable] HEROS chat means nothing over here in the UK

Make Jack sick to treat these guys this way, an utter liberty.

I remember them lost as Kings Cross, 9 lost at Milwall, Wimbledon yes i knew him Tony from Wimbledon - is nothing worth a fair living?????? $40,000 is not so much from a gusy in this line of work ---

Would you do it - and could you do it???

Guys take care of us all PLEASE!!!