whole numbers

  1. R

    Return only whole numbers

    Hello , I am trying to make a condensed table(White picture Circled in Red) from returning values in another table(Yellow table). I only want to return the whole numbers without leaving blank spaces. I am currently trying to find the best way to do this. I do not know if its possible to do...
  2. T

    I need Help Multiplying Whole Numbers!!

    I'm trying to calculate commissions for my team. They get $100 per unit sold once they hit 9. But if its a half deal (.5) they do not get $50 instead. Only on full deals. example: 1-8 deals = 0 bonus 9 deals = $900 9.5 deals = $900 10 deals=$1000 and so on but with my formula 9.5 deals= $950...
  3. A

    Return blank if cell empty - tweaking a formula

    Hello I pinched this really nifty formula for identiying round sums in a cell but now need to tweak it so it returns a blank if the cell it is looking at contains nothing. Be very grateful for you help.:) Thanks Angelo =IF(INT(A1)=A1,"Whole Number",IF(INT(A1)+0.5=A1,"Half Nmber","Other Number"))

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
Back
Top