software

Would like to subtract an amount from a certain value I enter at the time of
typing the formula if the item is from certain category

For example:

category amount total
video $17 =sumif(category = video, subtract amount
from a given value)Any suggestions would be appreciated.

Best Regards,
Eleanor--
Estandardtime Realty

=IF(A2=quot;videoquot;,100-B2,quot;quot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Eleanor Mquot; gt; wrote in message
...
gt; Would like to subtract an amount from a certain value I enter at the time
of
gt; typing the formula if the item is from certain category
gt;
gt; For example:
gt;
gt; category amount total
gt; video $17 =sumif(category = video, subtract amount
gt; from a given value)
gt;
gt;
gt; Any suggestions would be appreciated.
gt;
gt; Best Regards,
gt; Eleanor
gt;
gt;
gt; --
gt; Estandardtime Realty
Thanks.

Best of luck in your endeavors.
Eleanor
--
Estandardtime Realtyquot;Bob Phillipsquot; wrote:

gt; =IF(A2=quot;videoquot;,100-B2,quot;quot;)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Eleanor Mquot; gt; wrote in message
gt; ...
gt; gt; Would like to subtract an amount from a certain value I enter at the time
gt; of
gt; gt; typing the formula if the item is from certain category
gt; gt;
gt; gt; For example:
gt; gt;
gt; gt; category amount total
gt; gt; video $17 =sumif(category = video, subtract amount
gt; gt; from a given value)
gt; gt;
gt; gt;
gt; gt; Any suggestions would be appreciated.
gt; gt;
gt; gt; Best Regards,
gt; gt; Eleanor
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Estandardtime Realty
gt;
gt;
gt;