English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

I need a formula wich will create the sum red when it equals a minus.

2006-11-14 11:02:15 · 2 answers · asked by Anonymous in Science & Mathematics Mathematics

2 answers

This formula will put a minus sign in a second column's entry when the first column's entry is a minus or the positive value if positive.
A1=first entry
A2=second entry
Put into A2:
=IF(A1>0,A1,"-")

2006-11-14 11:13:06 · answer #1 · answered by maegical 4 · 0 0

In Excel, you can format the cells to do it for you.

Select the cells and go to Format: Cells...

In the box on the lower right, there is an area describing how to handle negative numbers.


There are alternate approaches, but not knowing what you are trying to do, or in what system, I don't want to go on at this point.

2006-11-14 19:14:00 · answer #2 · answered by novangelis 7 · 0 0

fedest.com, questions and answers