putting a number that is greater or lesser into different cell .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a way to be able to take a number say 30 as a base so that any number
30 or less is put in a cell but if it is larger than 30 then 30 is put into
that cell and everything over is put into another cell
 
Try this:

A1 = some number

B1: =(A1<>"")*MIN(A1,30)

C1: =MAX(0,A1-30)

Biff
 
You must log in or register to reply here.

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

Using greater than and lesser than formula 2
greater/lesser than 5
subtract one cell from each cell in a range and count instances 2
Finding and copying whole rows 1
Countif and values greater than zero for a named range 1
Need to calculate the number of days between two dates on a 30 day 5
taking numbers in vertical cells putting them in horizontal cells 3
Multiple Variables in Conditional Formatting with Excel 2003 1

Back
Top