Formula if cell is = to 0

[Kiwi den]

Hi all,

Having trouble trying to remember the formula to solve the following:
Column A has numbers in it, I would like for Column B to have a formula if the same Row number in column A is greater than 0 then a number 1 is entered into column B, if the same row in A is a 0 then nothing appears in column B

Hope that makes sence

eg cell A1 has value of 34, then cell B1 will equal 1
cell A2 has value of 25 then cell B2 will equal 1
cell A3 has value of 0 then cell B3 will equal 0

 

[shaowu459]

try B1=(A1>0)*1, copy down

 

[Kiwi den]

try B1=(A1>0)*1, copy down

Yip, works a treat, thank you

 

[shaowu459]

Yip, works a treat, thank you

thanks for the feedback and have a nice day

 

[Peter_SSs]

Yip, works a treat, thank you

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.