Need help creating formula that spits out whole numbers

[seven7rees]

[FONT=&quot]Picture of excel sheet: https://imgur.com/X9y9Lkn[/FONT]
[FONT=&quot]Hi,[/FONT]
[FONT=&quot]I need help with an excel formula that will allow me to change the monthly spend percentage (column D) which spits out into column C based on total revenue in column A. Here is the tricky part that I can’t figure out.[/FONT]
[FONT=&quot]In the first row I can spend up to $4,000 a month on widgets at $150 each, which comes to 26.67. I need a formula that spits out a whole # into column B. Hiding the decimal places does not work as this column feeds other columns. I also need the formula to not round up. If the true # is 26.67, then I need it to show 26.00. If we need to add/create other columns to help feed the formula, that is fine to.[/FONT]
[FONT=&quot]Thank you![/FONT]

 

[Rick Rothstein]

Since your numbers are always positive, the INT function will do what you want.