If A1 = 1 B1 (value) moves to C1(B1 value)

Closed
Stormdronk - May 21, 2010 at 02:09 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 21, 2010 at 05:57 AM
Hello, Please help!

If A1 = 1 B1 (value) moves to C1(B1 value)

A1 B1 C1
1 10000 10000

Thanks!!



Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 21, 2010 at 05:57 AM
If you just meant to show data in C1 the value of B1 when A1=1, you can use formula

=IF(A1=1, B1, "")
-1