Fred saves the day % retainage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=IF(H36>50%*H35,10%*E36,0)

I think I figured it out. Is their a better way to do this?

Thanks! Fred
 
An alternative way of expressing your formula is =(H36>50%*H35)*10%*E36

We don't know whether it's the correct answer to whatever original question
may have been asked, because you've started a new thread rather than
replying to the relevant previous thread.
 
Yep, sorry it was my first time on here. I feel like a dip now. The original
question is below.

I am trying to figure out a formula that will automatically figure retainage


Project Total=600,000 (H35)
=IF(H36>50%*H35,10%*E36,0) This appears to work, would using .5 be better?
 
You must log in or register to reply here.

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

Similar Threads

% Retainage info ---Sorry DUH! 5
Begging one more time....Stuck on this....tracking Retainage % 4
Confusing results 4
Invoice Retainage 2
if statement issues. 2
Use ROUND to return an average date 6
How to Handle FIND when character not present 5
Nested IF/OR/AND Statement Help 3

Back
Top