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