asked on # IF statement not calculating correctly

IF statement not calculating correctly

=IF(B29="","",roundup(B29*(D29+(P29/1000)-L29,0)) which is giving a result of -198.58, when it should be 50.14

for your ref

b29=25, d29=2.182, p29=235, L29=10.36

please assist

=IF(B29="","",roundup(B29*

for your ref

b29=25, d29=2.182, p29=235, L29=10.36

please assist

Microsoft ExcelMicrosoft Office

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

You have missed one closing parenthesis.

If you close the parenthesis after the L29 => L29**)**, you will get -199.

If you close the parenthesis after the (P29/1000) => (P29/1000)**)**, you will get 51

If you close the parenthesis after the L29 => L29

If you close the parenthesis after the (P29/1000) => (P29/1000)

thankyou experts.

What is the formula meant to calculate?

Also, how do you get a result of -198.58 when you are rounding to 0 decimal places?