SOLVED

Excel Formula Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2348564%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348564%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20was%20trying%20to%20type%20this%20formula%20in%20cell%3A%26nbsp%3B%3DIF(%24A%2425%3D%201%2CSQRT(E4%2F3)%2CIF(%24A%2425%3D2%2C(22%2BSQRT(484-(8%2C4*(75-E4))))%2F4%2C2%2CLN(E4)))%20.%20When%20I%20press%20enter%20the%20window%20appears%20and%20it%20says%20something%20like%3A%20there%20is%20a%20problem%20with%20this%20formula.%20This%20is%20original%20formula%3A%26nbsp%3B%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ll%C4%8D.PNG%22%20style%3D%22width%3A%20558px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280256iD5C9DC0587E79E5C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ll%C4%8D.PNG%22%20alt%3D%22ll%C4%8D.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eand%20when%20I%20tried%20to%20change%20something%20(%20like%20I%20did%20up%20there%20with%20%2C%20instead%20of%20%3B%20)%20the%20window%20that%20I%20already%20mentioned%20appears.%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2348564%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-2348608%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348608%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1052068%22%20target%3D%22_blank%22%3E%40Barbi2001%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20use%20point%20as%20decimal%20separator%2C%20you%20should%20use%208.4%20instead%20of%208%2C4%20and%204.2%20instead%20of%204%2C2%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(%24A%2425%3D%201%2CSQRT(E4%2F3)%2CIF(%24A%2425%3D2%2C(22%2BSQRT(484-8.4*(75-E4)))%2F4.2%2CLN(E4)))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2348629%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348629%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20thought%20I%20had%20already%20tried%20it.%3C%2FP%3E%3CP%3EProblem%20solved%2C%20thank%20you%20very%20much%20%3CLI-EMOJI%20id%3D%22lia_red-heart%22%20title%3D%22%3Ared_heart%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I was trying to type this formula in cell: =IF($A$25= 1,SQRT(E4/3),IF($A$25=2,(22+SQRT(484-(8,4*(75-E4))))/4,2,LN(E4))) . When I press enter the window appears and it says something like: there is a problem with this formula. This is original formula:  llč.PNG

and when I tried to change something ( like I did up there with , instead of ; ) the window that I already mentioned appears.

Please help.

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Barbi2001 

If you use point as decimal separator, you should use 8.4 instead of 8,4 and 4.2 instead of 4,2:

 

=IF($A$25= 1,SQRT(E4/3),IF($A$25=2,(22+SQRT(484-8.4*(75-E4)))/4.2,LN(E4)))

@Hans Vogelaar 

I thought I had already tried it.

Problem solved, thank you very much