How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
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
A new question is answered every 9 seconds

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

 

 

 

 

 

 

John D and 3 other Microsoft Office Specialists are ready to help you
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

 

 

 

John D and 3 other Microsoft Office Specialists are ready to help you