We help IT Professionals succeed at work.

excel 2016 - formula help

hi experts, could you please help me with this formula which needs a result of 11, not 1.

formula error 1
Comment
Watch Question

Roy CoxGroup Finance Manager

Commented:
When asking for Excel help then in most cases an example workbook is more useful than an image.

Can you show manual calculations how the answer is supposed to be 11?


From the visible data and from the formula the result should be 1.

Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
=IF(U5="","",(T5*U5*V5)*(1+W5%))

Open in new window