invoices

T

toll

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.
 
V

via135

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
 
V

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
 
Top