Formula

[Johnboy28]

I'm after a formula that can give me - if cell equals Zero it will return 0 (Not Blank), and will return 1 if greater then zero. Thank you

Total Feed Cost	Results
$25.00
$36.00
$25.00
$25.00
$0.00
$0.00
$0.00
$24.00
$21.00

 

[DanteAmor]

How about

varios 23oct2024.xlsm
	A	B
1	Total Feed Cost	Results
2	$25.00	1
3	$36.00	1
4	$25.00	1
5	$25.00	1
6	$0.00	0
7	$0.00	0
8	$0.00	0
9	$24.00	1
10	$21.00	1
Hoja3

Cell Formulas
Range	Formula
B2:B10	B2	=IF(A2,1,0)

 

[Johnboy28]

Thank you. Much Appreciated

 

[Eric W]

Or:

=SIGN(A2)

 

[Johnboy28]

Or:

=SIGN(A2)

Thanks you. That works too

 

[Peter_SSs]

If you are using your 365 version you can do all the rows at once without copying down by adapting either of the previous suggestions or yet another variation as below.

24 10 24.xlsm
	A	B	C	D
1	Total Feed Cost	Results	Results	Results
2	$25.00	1	1	1
3	$36.00	1	1	1
4	$25.00	1	1	1
5	$25.00	1	1	1
6	$0.00	0	0	0
7	$0.00	0	0	0
8	$0.00	0	0	0
9	$24.00	1	1	1
10	$21.00	1	1	1
Zero or above

Cell Formulas
Range	Formula
B2:B10	B2	=IF(A2:A10,1,0)
C2:C10	C2	=SIGN(A2:A10)
D2:D10	D2	=--(A2:A10>0)
Dynamic array formulas.

 

[Johnboy28]

If you are using your 365 version you can do all the rows at once without copying down by adapting either of the previous suggestions or yet another variation as below.

24 10 24.xlsm
	A	B	C	D
1	Total Feed Cost	Results	Results	Results
2	$25.00	1	1	1
3	$36.00	1	1	1
4	$25.00	1	1	1
5	$25.00	1	1	1
6	$0.00	0	0	0
7	$0.00	0	0	0
8	$0.00	0	0	0
9	$24.00	1	1	1
10	$21.00	1	1	1
Zero or above

Cell Formulas
Range	Formula
B2:B10	B2	=IF(A2:A10,1,0)
C2:C10	C2	=SIGN(A2:A10)
D2:D10	D2	=--(A2:A10>0)
Dynamic array formulas.

Thank you very much. Appreciate your help.

 

[Peter_SSs]

You are welcome. Glad to contribute.