Home

Format an equation

%3CLINGO-SUB%20id%3D%22lingo-sub-565254%22%20slang%3D%22en-US%22%3EFormat%20an%20equation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-565254%22%20slang%3D%22en-US%22%3EHi%2C%20I%20have%20an%20equation%20I%E2%80%99m%20trying%20to%20generate%20in%20one%20cell%20based%20off%20rather%20or%20not%20another%20cell%20is%20greater%20than%2Fless%20than%2Fequal%20too%20a%20certain%20percentage.%20I%E2%80%99ve%20tried%20using%20%E2%80%9CIf%20function%E2%80%9D%20but%20can%E2%80%99t%20seem%20to%20get%20it%20put%20together%20correctly.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-565254%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-565482%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20an%20equation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-565482%22%20slang%3D%22en-US%22%3EWhat's%20your%20IF%20formula%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-566066%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20an%20equation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-566066%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F341745%22%20target%3D%22_blank%22%3E%40Jeremiah2315%3C%2FA%3E%26nbsp%3B%2C%20as%20variant%20that%20could%20be%20nested%20IF%20like%3C%2FP%3E%0A%3CPRE%3E%3DIF(A1%26gt%3BP1%2C1%2CIF(A1%26lt%3BP1%2C-1%2C0))%3C%2FPRE%3E%0A%3CP%3Eas%20well%20as%20other%20formulas.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Jeremiah2315
Occasional Visitor
Hi, I have an equation I’m trying to generate in one cell based off rather or not another cell is greater than/less than/equal too a certain percentage. I’ve tried using “If function” but can’t seem to get it put together correctly.
2 Replies
What's your IF formula?

@Jeremiah2315 , as variant that could be nested IF like

=IF(A1>P1,1,IF(A1<P1,-1,0))

as well as other formulas.

 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
11 Replies