Forum Discussion
Solved
Excel Formula Problem
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 i...
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)))
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)))
