percentage within a formula

[nparsons75]

Hi, Im hoping this is really simple.

I have a value in hours, 7.5.

I have 2 cells. A1 = 7.5 A2 = 25% In A3 I would like the answer to equal 5.63

I would like to do this without having to type 0.75 in cell A2.

I need 7.5 - 25% in a formula?

Is this possible?

Thanks,

 

[steve the fish]

Do you mean like:

=A1*(1-B1)

 

[nparsons75]

Yes that seems to work but it has now created a differnet issue, kind of...

I need this formula:

=(C42*C47*(C43)/C47)*0.75

To be

=(C42*C47*(C43)/C47)-C48

=(25*7.5*(21)/7.5)-25%

Where C48 = 25%

Hope this makes sense.

 

[steve the fish]

What is the 21 and 25??

 

[steve the fish]

This formula you wrote:

=(C42*C47*(C43)/C47)*0.75

ignores the 7.5 altogether as C47/C47 = 1

 

[nparsons75]

the 25 is a value in cell C42, the 21 is a value in C43.

=(C42*C47*(C43)/C47)*0.75

or

=(25*7.5*(21) / 7.5)-25%

Sorry, am I missing something. Thanks

 

[steve the fish]

I think you are yes. This formula:

=(C42*C47*(C43)/C47)*0.75

is the same as

=C42*C43*0.75

so you are ignoring C47 altogether. I presume that isnt intentional.