Hello| Formula To Return 1 if positive, o, if negative

**scuba2x2** · 03-03-2013, 09:18 AM

Hi everyone,
I am scuba2x2 and am a pretty new member to this forum.
Very happy to have been reviewing everyone's previous threads, comments tips and tricks!

Thanks!

so my very basic problem, I'm sure -is something that is just bugging me-
I am manipulating data for work and am looking at a column of total award amounts.

I have another column that's lists the amount of the award that is for MY group

i would like to populate another column that shows a '1' if that Pgroup amount is >0
a '0' if there is no Pgroup amount (and a '2' for a negative or credit amount for Pgroup if
i can get the first 2 to work)

total amount | Pgroup amount | PG>0
10,000 0 0
10,000 6,000 1
10,000 -(6,000) 2

to start..
i am using
=(L18)*0.8
and it is simple and should work

I either have a currency ($25,000.00) or 0.00
in column L and when 0.00 is there and a '0' should be displayed -
i am still getting '1'

- thoughts-
or is my error glaringly obvious?

thanks!

**scuba2x2** · 03-03-2013, 09:30 AM

i actually think my formula is correct but when i populate it down the column, i have to somehow 'activate' the formula by clicking into the formula bar for each cell in the column else it will not evaluate. i notice the criater is not blue or 'active' until I do this:

ex:
non active and not evaluation: =IF(M8 >0, 1, 0)
active and evaluating correctly =IF(M8 >0, 1, 0)

**scuba2x2** · 03-03-2013, 09:31 AM

i actually think my formula is correct but when i populate it down the column, i have to somehow 'activate' the formula by clicking into the formula bar for each cell in the column else it will not evaluate. i notice the criater is not blue or 'active' until I do this:

ex:
non active and not evaluation: =IF(M8 >0, 1, 0)
active and evaluating correctly =IF(M8 >0, 1, 0)

**martindwilson** · 03-03-2013, 09:33 AM

make sure your cell is formatted general(well anything but text) before you enter the formula,also check calculation is set to auto in excel options

**scuba2x2** · 03-03-2013, 09:39 AM

thanks Marin-
auto-calculate in options made a difference -thank you.

(General forum help: I don't see where to delete when I select 'edit') - that's why I have these duplicated posts.
i am trying to figure that one out ...)

thanks again

scuba2x2