Get instant live expert help on true or false in excel
“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
If A is True, or B is True, or C is True, or D is True, then E is False, but if A-D is False then E is True, please help me to create a formula.
Solved by F. A. in 22 mins
I am attempting to move away from MSWorks and have imported a .wbd Works Database file into MS Excell. There are fields that were originally "formatted" as "TRUE/FALSE" that now only contain the text of either "TRUE" or "FALSE" How can I correct this so that 0 will display as FALSE and 1 (or any other number) will display as TRUE as it did in Works?
Solved by S. J. in 19 mins
I just need a formula to return a true or false value.
Solved by O. L. in 11 mins
How to let users select the range of values of X and Y in Regression using Excel VBA Sub trail() Application.Run "ATPVBAEN.XLAM!Regress", ActiveSheet.Range("$H$1:$H$" & Range("H" & Rows.Count).End(xlUp).Row) _ , ActiveSheet.Range("$I$1:$L$" & Range("L" & Rows.Count).End(xlUp).Row), False, True, 95, ActiveSheet.Range( _ "$V$2"), True, True, False, False, , False End Sub
Solved by F. E. in 13 mins
I have 6 cells with True and false, 5 of them are false and 1 is true, I want excel to choose the one thats true and then display a different cell whats accociated to it
Solved by G. H. in 23 mins