Add number using if formula

[Umer123]

Hi All,

I need a formula using an if function that add +1 on per $1000 of cell value if exceeds from $10,000

$950	10
$10,000	10
$10,001	11
$11,001	12

Thanks in advance...

 

[mamady]

Dear Umer,

Please try the below:

Book1
	A	B
1	$50	10
2	$10,000	10
3	$10,001	11
4	$11,001	12
5	$12,100	13
6	$11,999	12
Sheet1

Cell Formulas
Range	Formula
B1:B6	B1	=IF(A1<=10000,10,ROUNDUP(A1/1000,0))

Regards

 

[Fluff]

Another option

=MAX(10,ROUNDUP(A2/1000,0))