IF statement not calculating correctly

Frank .S
Frank .S used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Try

=IF(B29="","",ROUNDUP(B29*(D29+(P29/1000))-L29,0))
NorieAnalyst Assistant

Commented:
Frank

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?
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
Frank .SBuilding Estimator

Author

Commented:
thankyou experts.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial