Home

Excel formula is not working eg A1 =10 --- =if(A1>5,3,0) Gives error message?

%3CLINGO-SUB%20id%3D%22lingo-sub-649290%22%20slang%3D%22en-US%22%3EExcel%20formula%20is%20not%20working%20eg%20A1%20%3D10%20---%20%3Dif(A1%26gt%3B5%2C3%2C0)%20Gives%20error%20message%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-649290%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20formula%20is%20not%20working%20example%20A1%20%3D10%20---%20%3Dif(A1%26gt%3B5%2C3%2C0)%20Gives%20error%20message%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-649290%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-649516%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20is%20not%20working%20eg%20A1%20%3D10%20---%20%3Dif(A1%26gt%3B5%2C3%2C0)%20Gives%20error%20message%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-649516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F349275%22%20target%3D%22_blank%22%3E%40CJ-Coki%3C%2FA%3E%26nbsp%3B%2C%20do%20you%20mean%3C%2FP%3E%0A%3CPRE%3E%3DIF(A1%26gt%3B5%2C3%2C0)%3C%2FPRE%3E%0A%3CP%3Egives%20an%20error%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-650461%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20is%20not%20working%20eg%20A1%20%3D10%20---%20%3Dif(A1%26gt%3B5%2C3%2C0)%20Gives%20error%20message%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650461%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F349275%22%20target%3D%22_blank%22%3E%40CJ-Coki%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eam%20having%20a%20problem%20with%20LINEST%20-%20cannot%20see%20stats%2C%20even%20if%20I%20add%20TRUE%20as%20fourth%20argument%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
CJ-Coki
Frequent Visitor

Excel formula is not working example A1 =10 --- =if(A1>5,3,0) Gives error message?

 

 

2 Replies

@CJ-Coki , do you mean

=IF(A1>5,3,0)

gives an error?

 

@CJ-Coki 

 

am having a problem with LINEST - cannot see stats, even if I add TRUE as fourth argument

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies