Formula - Show the value of one cell in anoth

Closed
Dan S - Sep 19, 2009 at 07:59 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 19, 2009 at 08:39 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 19, 2009 at 08:39 PM
use if function . see help "if"
0