Add or discount % formula

[hecgroups]

Hello,

I am seeking help on correction of formula. Here are the details below.

The cell B4 should display the result for all calculation.

B4 = L16+O28*B15*G16
50+100=150+*10%=165*10%=181.5

B4=181.5

I hope the above mentioned is clear to help me to solve this issue.

Please see the attached file.

[AlphaFrog]

Try this..

= (L16+O28)*(1+B15)*(1+G16)

Note: The value in O28 is actually 99.741 and not 100 so the result is 181.19

This will round O28 to 100
= (L16+ROUND(O28,0))*(1+B15)*(1+G16)

[hecgroups]

Hai Alphafrog.

I want to diaplay the value of L16 in B4 then the calculation. if the calculation values is not their the B4 value remains as L16 value

[AlphaFrog]

hai alphafrog.

I want to diaplay the value of l16 in b4 then the calculation. If the calculation values is not their the b4 value remains as l16 value

Try this...

=IF((O28*B15*G16)=0,IF(L16="","",L16),(L16+O28)*(1+B15)*(1+G16))

[hecgroups]

i have try your formula but i have to enter all the fields. if i enter only b15 it is not taking. and it is not taking values from O28 also. Just it is showing the value of l16

[AlphaFrog]

i have try your formula but i have to enter all the fields. if i enter only b15 it is not taking. and it is not taking values from O28 also. Just it is showing the value of l16

I thought that's what you wanted.

Then I don't understand what this means...

I want to diaplay the value of L16 in B4 then the calculation. if the calculation values is not their the B4 value remains as L16 value

[hecgroups]

What i am trying to say is the B4 should read the valuefrom L16 without any calcualtion OK. If O28, B15 or G16 have any values the it should calculate as i said above. These cells can have values or empty.I hope you uderstand what i want. It is little bit complicated.

[AlphaFrog]

If O28, B15 or G16 have any values

This will calculate if any one of O28, B15 or G16 has a value
=IF((O28+B15+G16)=0,IF(L16="","",L16),(L16+O28)*(1+B15)*(1+G16))

[hecgroups]

Thanks Mr. AlphaFrog. It works if i ahve any problem i will get back to you for your help.