colinharwood
Active Member
- Joined
- Jul 27, 2002
- Messages
- 426
- Office Version
- 2019
- Platform
- Windows
Hi
Is it possible to write a formula to enter a negative value from another cell ie
Col A = yes or no
Col B = assorted numbers
Col C formula
=if(A1=yes,negative value of B1,0)
Thanks
colin
Is it possible to write a formula to enter a negative value from another cell ie
Col A = yes or no
Col B = assorted numbers
Col C formula
=if(A1=yes,negative value of B1,0)
Thanks
colin