Help with business excel formula

I need someone to help me with an Excel file formula...Please PM me . What it is....I want to calculate a number say 95%(on cell H13) it would times it by .78 divided by 12(on cell D13).

What I want is say I put 89% on H13 I want it to calculate times .52 divided by 12.

So 90% to 100%(on cell H13) times it by .78 divided by 12. (would show up on D13).

say 89% to 80% I want it to times it by .52 divided by 12.

If you are confused I will gladly send my file and talk to you about it.

Please Help!

Miknow said:

I need someone to help me with an Excel file formula...Please PM me . What it is....I want to calculate a number say 95%(on cell H13) it would times it by .78 divided by 12(on cell D13).

What I want is say I put 89% on H13 I want it to calculate times .52 divided by 12.

So 90% to 100%(on cell H13) times it by .78 divided by 12. (would show up on D13).

say 89% to 80% I want it to times it by .52 divided by 12.

If you are confused I will gladly send my file and talk to you about it.

Please Help!

Click to expand...

email it to me @ [email protected]

hmmm I tried to email from 2 different accounts and you can't receive them but anyway I did some research and this is what I got so far

=IF(H13<80.01%,0,IF(H13<89.99%,(D13*0.0052)/12))

I want to add this if its less than 100% D13*0.0078/12 I tried to write it in but its giving me an error

=IF(H13<80.01%,0,IF(H13<89.99%,(D13*0.0052)/12)),IF(H13<100.00%,(D13*0.0078)/12))

so to make it simple if its less than 80.01 no value. if its 80.01 to 89.99 I want it to do D13 value times 0.0052 divivded by 12. If its 90.00 to 100 I want it to D13 times 0.0078 divided by 12.

I got up to the 2 part 0.0052 but some how I cannot write the 90.00 to 100 part

[email protected]. Sorry. Add me cmw82352 to AIM if you want.

Initial thoughts are that you're putting too much formula on one line. But it's possible to do what I THINK your'e trying to do. email me the spreadsheet.

excel only excepts so many if statments in a single cell. There was something else you could use but i forgot what it was.

=if(h13>99.99%,(d13*0.0098/12),if(h13>90%,(d13*0.0078/12),if(h13>80.01%,(d13*0.0052/12),0)))

^^ genius. Excel Pro!.

<----stupid