simple IF statement for positive/negative #s

Question

Hello,

I want to create a simple if statement to test a specific cell. If the number is A1 is negative then *-1, if its positive leave it alone as it is. How would I go about doing this?

Thanks,

EA

Answer 1

Hi,

Try this

=ABS(A1)

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 2

Hi,

=if(A1<0,A1*-1,A1)

Answer 3

hello to all

i need some help on formulation as above :

design target  design actual  costing target   costing actual   mkt target     mkt actual

05-04-2016      06-04-2016     07-04-2016        09-04-2016      11-04-2016  12-04-2016

as per target and actual days for all delay days calculated in seperate column and if delay of days it will be added in next dept target date as per previous.

if days are in plus i.e. 1,2,3 then it will added smoothly but if any depatment completed his/her target before target date then days are in miuns i.e. -1,-2 so how for next department date is calculated if -1 or any value i.e. in -.

Answer 4

Thanks, ABS and =if(A1<0,A1*-1,A1) both works, ABS is easier.

Answer 5

Hello,

I want to create a simple if statement to test a specific cell. If the number is A1 is negative then *-1, if its positive leave it alone as it is. How would I go about doing this?

Thanks,

EA

In other words, you want all the numbers to be positive?

Try this...

A1 = some number, could be positive or negative

Enter this formula in B1:

=ABS(A1)

--

Biff

Microsoft Excel MVP