Function Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am tryin to find a function that can help me to do calculations
For example, Cell A2=20 and I am suppose to show a fig in cell A3 which has a formula that show
if A2 is greater than 0, then minus the A2 figure
if A2 is smaller than 0 (say a negative figure). then add the A2 figure

How am I going to do it in excel spreadsheet

Thanks!!
 
Hi
try something like
=some_value-ABS(A2)
-----Original Message-----
Hi!

I am tryin to find a function that can help me to do calculations.
For example, Cell A2=20 and I am suppose to show a fig in
Click to expand...
cell A3 which has a formula that shows
 
Back
Top