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(A1gt;=3,A1lt;6),A1-(A1*10%),IF(A1gt;=6,A1-(A1*15%),quot;quot;))
assuming your number is in A1-VIA135
toll Wrote:
gt; does you know how to create a formula that will select one of two
gt; formulas
gt; that deduct a percentage 10 or 15 depending on whether a value in
gt; another
gt; cell is greater than 3 but less than 6, or greater than or equal to 6.
gt; it is
gt; for part of an invoice/daily records worksheet.--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=523183
hi!
may be like this!
B1: =IF(AND(A1gt;=3,A1lt;6),A1-(A1*10%),IF(A1gt;=6,A1-(A1*15%),quot;quot;))
assuming your number is in A1-VIA135
toll Wrote:
gt; does you know how to create a formula that will select one of two
gt; formulas
gt; that deduct a percentage 10 or 15 depending on whether a value in
gt; another
gt; cell is greater than 3 but less than 6, or greater than or equal to 6.
gt; it is
gt; for part of an invoice/daily records worksheet.--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=523183
留言列表
