Home

formuale help

%3CLINGO-SUB%20id%3D%22lingo-sub-1197343%22%20slang%3D%22en-US%22%3Eformuale%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1197343%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20formulae%26nbsp%3B%3CFONT%3E%3D(A34%2F(C34-B34)*D34)%2BB34%2F2%3C%2FFONT%3E%20%26nbsp%3B%20however%20if%20no%20figures%20are%20input%20it%20gives%20me%20a%20divxerror%20how%20do%20i%20not%20get%20this%20im%20not%20quite%20understanding%20t%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1197343%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1197367%22%20slang%3D%22en-US%22%3ERe%3A%20formuale%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1197367%22%20slang%3D%22en-US%22%3EYou%20need%20to%20attach%20a%20sample%20file%20and%20explain%20what%20you%20intend%20to%20achieve%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1197681%22%20slang%3D%22en-US%22%3ERe%3A%20formuale%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1197681%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F473717%22%20target%3D%22_blank%22%3E%40Gavc1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%2C%20you%20need%20to%20wrap%20your%20formula%20with%20IFERROR%20like%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DIFERROR(A34%2F(C34-B34)*D34%2BB34%2F2%2C%3CSTRONG%3E0%3C%2FSTRONG%3E)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ENote%20that%20the%20above%20formula%20returns%20%3CSTRONG%3E0%3C%2FSTRONG%3E%20if%20your%20original%20formula%20results%20in%20an%20error.%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a formulae =(A34/(C34-B34)*D34)+B34/2   however if no figures are input it gives me a divxerror how do i not get this im not quite understanding t

2 Replies
Highlighted
You need to attach a sample file and explain what you intend to achieve
Highlighted

@Gavc1 

Perhaps, you need to wrap your formula with IFERROR like this: 

=IFERROR(A34/(C34-B34)*D34+B34/2,0)

Note that the above formula returns 0 if your original formula results in an error.

Related Conversations