invoices

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

Guest

does you know how to create a formula that will select one of two formulas
that deduct a percentage 10 or 15 depending on whether a value in another
cell is greater than 3 but less than 6, or greater than or equal to 6. it is
for part of an invoice/daily records worksheet.
 
hi!

may be like this!

A2: =IF(AND(A1>=3,A1<6),A1-(A1*10%),IF(A1>=6,A1-(A1*15%),""))

assuming your number is in A1


-VIA135
 
hi!

may be like this!

B1: =IF(AND(A1>=3,A1<6),A1-(A1*10%),IF(A1>=6,A1-(A1*15%),""))

assuming your number is in A1


-VIA135
 

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

Excel Average dates help 0
Excel Need Countifs Formula Help 0
conditional formula 2
how do I get a result if one cell is X and the 2nd cell is Y where 5
Coloured backgrounds using IF 3
If formula 3
return different values based on 4 criteria? 4
Problem calculating with a SUMIF 7

Back
Top