Excel Excel Formula - IF Function with percentages


Joined
Apr 24, 2017
Messages
1
Reaction score
0
Hi - I am a fairly basic excel user and have created a spreadsheet to record contract retentions.

I need a formula that calculates 10% of contract & variations until 5% of contract Total is reached. After this is reached I need it to change to 5% of a different column ie.



What I have come up with is:

=IF(F11<C8,E11*0.1,D11*0.05)

This doesn't seem to work though as it's only calculating the 10%. Sometimes the variation will be $0 so no retention will be paid at all.
I've tried attaching my excel spreadsheet but it won't allow .xlxs extension

Thank you in advance.
Jodie
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,510
I don't know what any of those cells relate to, would it be possible to give more details or a screenshot?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top