Get instant live expert help on how to type not equal sign
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
We found a problem with this formula. Not trying to type a formula? When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula: you type: =1+1, cell shows: 2 To get around this, type an apostrophe ( ' ) first: you type: '=1+1, cell shows: =1+1
Solved by O. B. in 14 mins
I am trying to do linear regression in Excel . But I am getting an error "There's a problem with this formula. Not trying to type a forumal? When the first charcter is an equal(=) or minus (-) sign, Excel thinks it's a formula. you type: =1=1, cell shows : 2 To get around this, type an apostrphe (') firts: you type: '=1=1, cell shows: =1+1"
Solved by G. Q. in 27 mins
I want to use a formula that says if cells in column H are greater than 12 in value, then give me "yes" if not give me "no". My formula: =IF(H2">="&12,"YES","NO") It is showing this error: Not trying to type a formula? When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula: you type: =1+1, cell shows: 2 To get around this, type an apostrophe ( ' ) first: you type: '=1+1, cell shows: =1+1
Solved by A. L. in 30 mins
Must start with an equal sign G). You can entera formula with + sign from the number pad; and Exce/ wi// convert it to an = sign. Add + (cell A3) Subtract -B 1 (cell C 1) Multiply (cell DI) Divide =AI/BI (cell El)
Solved by D. A. in 12 mins
I want help so i can make a formula that will compare numbers in two cells and if they are equal to display an equals sign. if one is less to display a minus sign and if one is bigger to display a plus sign
Solved by M. J. in 16 mins