invoices
 

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.

invoices
 

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

toll Wrote:
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.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=523183

invoices
 

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

toll Wrote:
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.


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=523183