adding in exel
thanks for the reply, the and so on is, $251 to $350 add $60 - $351 to $500
add $75
$501 - $700 add $90 - $701 to $1000 add $110 - and $1001 and up add $
200, and i'm not familiare with IF or VLOOKUP please exsplane .
thanks again
Morefeusdirect.com
"CLR" wrote:
There's no way to do what you ask, staying within the one column by using
formulas.....as a cell can contain either a value, or a formula......it
might be done using code, but more details would be needed for the "and so
on" part......a better solution would probably be by using a helper column
with an appropriate IF or VLOOKUP type formula.......still the range beyond
$250 would have to be defined.
Vaya con Dios,
Chuck, CABGx3
"Morefeus Direct" wrote in
message ...
hi, i have a problem, i'm trying to add to numbers in a column, i have a
column with 1000 different prices, is there a way to add to the different
groups within this column? "example" prices from $0 to $75.00 add
$25.00
- $76.00 to $150.00 add $30.00 - $151.00 to $250.00 add $50.00
and so on, all within this one column and all in the different groups?
thanks
Morefeusdirect.com
|