• 100% Satisfaction Guarantee
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now

# Can you tell me what a formula in Excel means (1-.65*.5)

### Resolved Question:

Can you tell me what a formula in Excel means? =(1-.65*.5)*c29
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  John D replied 5 years ago.

Hi,

The value in cell C29 is multiplied by 1 minus one half of 0.65

which is: C29 times 0.675

Hope this helps. Let me know if you have any questions

Customer: replied 5 years ago.
ok I am not sure I understand.
I don't understand how you come up with the number .675 Here are 2 formulas
=(1-.65*.5)*C29 or 337.59 and =(1-.65*.75)*C29 or 337.59. I just can't come up with the same number on the calculator as what the formula calculates.
Expert:  John D replied 5 years ago.

Ok I need to know the value that you have in cell C29

Customer: replied 5 years ago.
\$337.59
Expert:  John D replied 5 years ago.

Ok, here you go

=(1-.65*.5)*C29

first take 0.65*0.5 which is equal to 0.325

then subtract that number from 1 and you get 0.675, i.e.

1 - 0.325 = 0.675

finally multiply that result by the value in C29 which is 337.59, and you will get 222.87325

0,675 * 337.59 = 222.87325, which is 222.87