SOLVED

Simple formulas returning zero!

%3CLINGO-SUB%20id%3D%22lingo-sub-2710711%22%20slang%3D%22en-US%22%3ESimple%20formulas%20returning%20zero!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2710711%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20read%20answers%20to%20similar%20problems%20but%20can't%20relate%20them%20to%20my%20problem%2C%20which%20will%20be%20easy%20for%20you%20guys%20I'm%20sure.%3C%2FP%3E%3CP%3EWhy%20do%20the%20formulas%20in%20I18%20and%20I19%20return%20values%20of%20zero%3F%3F%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3CP%3EBen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2710711%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-2710741%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20formulas%20returning%20zero!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2710741%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169821%22%20target%3D%22_blank%22%3E%40Benet%20Gregory%3C%2FA%3E%26nbsp%3BYou%20have%20formula%20in%20F28%2C%26nbsp%3B%3CSTRONG%3E%3DE28*E28%2BF28%3ACF311%3C%2FSTRONG%3E%20which%20is%20causing%20a%20circular%20reference.%20You%20probably%20need%20to%20change%20it%20to%26nbsp%3B%3CSTRONG%3E%3DE28*E28%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2710751%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20formulas%20returning%20zero!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2710751%22%20slang%3D%22en-US%22%3ERiny%20thanks%20very%20much%2C%20v%20clever%20to%20spot%20that.%3CBR%20%2F%3ECheers%3CBR%20%2F%3EBen%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

I have read answers to similar problems but can't relate them to my problem, which will be easy for you guys I'm sure.

Why do the formulas in I18 and I19 return values of zero??

Many thanks

Ben

2 Replies
best response confirmed by Benet Gregory (Occasional Contributor)
Solution

@Benet Gregory You have formula in F28, =E28*E28+F28:CF311 which is causing a circular reference. You probably need to change it to =E28*E28

Riny thanks very much, v clever to spot that.
Cheers
Ben