combining functions ??

fflan513

New Member
Joined
Oct 18, 2002
Messages
8
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?
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
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
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
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???

:cry: Guys take care of us all PLEASE!!!
 

Forum statistics

Threads
1,144,743
Messages
5,726,025
Members
422,654
Latest member
Yashpalknl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top