Return calculated value with some condition - 1. show result as 0 / 2.show result +1

[newtoexcell]

Hi guys,

I would like some help here, same as mention in title but let me get into detail.

Let say I have number in A1 and B1, B1 suppose to minus with A1.

In C1, I need some formula which can return value with follows condition.

1. if result is positive and >0, +1 and show in C1
2. if result is 0, show 0 in C1
2. if result is negative, just show 0 in C1

 

[Alex Blakenburg]

I am not sure I understand what you are trying to do. Do you just mean something like this /

Book1
	A	B	C
1	100	60	1
Sheet1

Cell Formulas
Range	Formula
C1	C1	=0+((A1-B1)>0)

 

[newtoexcell]

Hi Alex, sorry for not being clear. Let me give you some scenario, hope it could help you.

1.if result is positive and >0, +1 and show in C1
Example: A1=60, B1=100, (B1-A1), C1 should be 41 (result =40 then +1)

2. if result is 0, show 0 in C1
Example: A1= 100, B1=100, (B1-A1), C1 should be 0 (no need to +1)

3. if result is negative, just show 0 in C1
Example: A1=100, B1=60, (B1-A1), C1 should be 0 (result =-40 but display as 0)

 

[Automatrix]

Book1
	A	B	C
1	100	60	0
2	100	100	0
3	60	100	41
Sheet1

Cell Formulas
Range	Formula
C1:C3	C1	=IF((B1-A1)>0,B1-A1+1,0)

 

[newtoexcell]

Book1
	A	B	C
1	100	60	0
2	100	100	0
3	60	100	41
Sheet1

Cell Formulas
Range	Formula
C1:C3	C1	=IF((B1-A1)>0,B1-A1+1,0)

It work just fine!

Thanks a lot for your help

 

[Automatrix]

It work just fine!

Thanks a lot for your help

You're welcome. Please mark the post as a solution to help the search engine.