nested if formula with True or False condition

[kishore k]

hi, I need a "if" formula with below case

in cell A1 i have amount 55000(positive), in cell B1 I have sign "+". similarly, in A2 i have amount -25000 (negative) and in cell B2 sign "-" . the signs +/- are manually input based on requirement.. now the formula should tell me if the amount in A1 is positive amount and sign in A1 is "+" sign, then the formula to tell as true.. as well it amount is negative and sign is also "-" then true..

if any blanks are other signs, it has to through "false"..

 

[r1998]

Hello Kishore Bhai
In B1 use this formula and drag down

=IF(SIGN(A1) = -1,"-",IF(SIGN(A1)=1,"+",""))

 

[kishore k]

Thank you Bhai..ray:. it works.. also is it possible to extend the formula for B1, i.e if A1 having positive number and B1 having "+" sign, then formula to be true..

 

[r1998]

if a1 has a positive number and b1 has a + sign, then c1 must show TRUE ?

 

[r1998]

use this in C1 and then drag down

=IF(B1="+", TRUE,IF(B1="-",FALSE,""))

 

[kishore k]

thanks again..