ExcelBanter - if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!!!

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!!! (https://www.excelbanter.com/excel-worksheet-functions/168811-if-a1-0-let-b2-%3Da1-if-a1-%3D0-let-b3%3Da1-solve-please.html)

techwiz101

if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!!!

i am trying to create a financial record Book. and i want evaluate if the
value of the number is negative and if so duplicate the value onto another
cell.

carlo

if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!!!

On Dec 7, 10:28 am, techwiz101
wrote:
i am trying to create a financial record Book. and i want evaluate if the
value of the number is negative and if so duplicate the value onto another
cell.

Put in B2: =if(A1<0,A1,"")
and in B3: =if(A1=0,A1,"")

hth

Carlo

techwiz101

if A1<0 let B2 =A1 and if A1=0 let B3=A1 solve PLEASE!!!!!!!!

"carlo" wrote:

On Dec 7, 10:28 am, techwiz101
wrote:
i am trying to create a financial record Book. and i want evaluate if the
value of the number is negative and if so duplicate the value onto another
cell.

Put in B2: =if(A1<0,A1,"")
and in B3: =if(A1=0,A1,"")

hth

Carlo

thank you very much

All times are GMT +1. The time now is 08:36 PM.