I hope you can help me... Excuse my english
I need to create a formula to calculate multiple ranges of prices.
Let me give you and example... The answer must be shown in column B
If the value is between 0 - 99999 i need it to sum 28000 to the column A and show it in column B
If the value is between 100000 - 199999 i need it to sum 38000 to the column A
If the value is between 200000 - 249999 i need it to sum 48000 to the column A
If the value is between 250000 - 499999 i need it to sum 58000 to the column A
If the value is between 500000 - 749999 i need it to sum 68000 to the column A
If the value is between 750000 - 999999 i need it to sum 78000 to the column A
and so on.
A -------------------------- B
96000
36000
128000
356000
458000
Thank in advance.
Bookmarks