asked on IF statement not calculating correctly
IF statement not calculating correctly
=IF(B29="","",roundup(B29*
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
Last Comment
Frank .S
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
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), you will get -199.
If you close the parenthesis after the (P29/1000) => (P29/1000)), you will get 51
ASKER
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?