Formula - Show the value of one cell in anoth

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I want a formula that allows the value in cell A1 to show in cell B1 if it is positive, and to show in cell C1 if it is negative?

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
use if function . see help "if"