How to calculate an amount in cell up to a constant amount
Lets say you want Cell A1 is the number that you want to determin which column you want it to go in...try this formual you might need to tweek it or message back and tell me what you need
----First Column-----
=IF(AND(500,000>=$A1,$A1>=0),A1," ")
----Second Column-----
=IF(AND(2,000,000>=$A1,$A1>=500,001),A1," ")
-----Third Column----
=IF(AND(5,000,000>=$A1,$A1>=2,000,001),A1," ")
so this way it will only appear in the column that it fits in and you can replace A1 with the formula
×