2 IF Conditions

[Megatronv]

Hi,

I would like a formula so that the new cell returns a positive number for when I have "B" in column G even if I have a negative number for "B".

Likewise when it is "S" I would like the new cell to return a negative number in both cases.

So, in my example s/s: I would like to get the below output:

Desired Result
B 100 100
S -89 -89
S 10 -10
B -5 5

[Bob Phillips]

Try this

=IF(G9="B",H9*SIGN(H9),IF(G9="S",-H9*SIGN(H9),H9))

[Pete_UK]

If column G can contain other values apart from "B" and "S", then you can use this formula:

=IF(G9="B",ABS(H9),IF(G9="S",-ABS(H9),""))

which will return a blank for any values that are not B or S. If column G can only be B or S, you could simplify it to this:

=IF(G9="B",ABS(H9),-ABS(H9))

Hope this helps.

Pete

[Megatronv]

Thanks a lot