nested if formula with True or False condition

kishore k

New Member
Joined
Jan 18, 2019
Messages
25
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"..
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

r1998

Board Regular
Joined
Sep 9, 2018
Messages
106
Hello Kishore Bhai
In B1 use this formula and drag down
Code:
=IF(SIGN(A1) = -1,"-",IF(SIGN(A1)=1,"+",""))
(y)
 
Last edited:

kishore k

New Member
Joined
Jan 18, 2019
Messages
25
Thank you Bhai..(y):pray:. 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

Board Regular
Joined
Sep 9, 2018
Messages
106
if a1 has a positive number and b1 has a + sign, then c1 must show TRUE ?
 

r1998

Board Regular
Joined
Sep 9, 2018
Messages
106
use this in C1 and then drag down
Code:
=IF(B1="+", TRUE,IF(B1="-",FALSE,""))
 

Watch MrExcel Video

Forum statistics

Threads
1,108,490
Messages
5,523,251
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top