Question about splitting a #

  • Thread starter Thread starter nyrfan
  • Start date Start date
N

nyrfan

If there a way to do this:

I want to make a sheet that when I input a number it breaks out into to
cells, for example:

I input 1200 in to A1

I want B1 to show 1000 of that and
B2 to show the remaining 200.

Thanks for the help

Felix
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question aobut splitting a number 12
Displaying a range based on a cell's contents 3
Copy Data from One sheet to Different Sheets 1
If question 3
Drop-down list and error message 1
Data Validation and drop-down list using IF, AND and what else? 8
Formula involving different sheets 1
dynamic vlookup then sum 3

Back
Top