Microsoft

Ask something
Question Locked

microsoft ECXEL help urgent

0 helpful
4 replies

by russellte2002 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Please help

cell A1 to A5 has a text value and cell B1 to B5 has a number value, if cell B1 to B5 present a negative value how can i automatically transfer only the negative value to C row of sheet2 and also transfer the text that represent that negative value from A1 TO A5 to D1 TO D5 of sheet 2

TNX

4 replies

by russellte2002

Hi,

what if i want it to AUTOMATICALLY TRANSFER the negative number value only(not the positive number value) to C row of another worksheet (worksheet2) and the text value that represent the negative number value.

tnx

by triathlete1981

go into formulas and create conditional functions that recognize if a value is negative or positive, create links to the source (neg/pos #s) and let the conditional functions take care of the rest.

This discussion is closed to new replies.