Forum Discussion
Help with formula to convert numbers to negative
Can anyone help with formula to convert numbers in cell to negative ones for the following scenario: IF cell=''text'' then convert to negative it also has to be nested with already exsiting for...
Do you mean convert keeping the number in the same cell. When VBA. If to put result into another cell, it could be
=IF(B1="text", -ABS(A1), A1)- Yes I did mean convert the number in the same cell
If so when only with VBA programming, but that's not my territory.
