formula

[dk]

I have a spread sheet that calculates my software
expenses over the next 5 years. I am using the number of
employees times the licensing cost per employee in my
formula. I have pre-paid for some of the licenses.

I have a row that shows the number of licenses I will
need each year. The first two years are negative numbers
since I purchased more than I currently need.

I need a formula that will not show a credit on the
dollars allocated each year since I have more than I need.

Thanks,

Donne

 

[Milly Staples [MVP - Outlook]]

Try posting this in a group that supports Excel.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After searching google.groups.com and finding no answer, dk asked:

| I have a spread sheet that calculates my software
| expenses over the next 5 years. I am using the number of
| employees times the licensing cost per employee in my
| formula. I have pre-paid for some of the licenses.
|
| I have a row that shows the number of licenses I will
| need each year. The first two years are negative numbers
| since I purchased more than I currently need.
|
| I need a formula that will not show a credit on the
| dollars allocated each year since I have more than I need.
|
| Thanks,
|
| Donne