Posted in xn--kfs74mzzid01b.com edit by anonym on January 7th, 2009
Ex: Inputter can enter either a monthly expense for an item or an
annual expense for the item. If she enters the monthly, the annual
must be calculated (monthly times 12), conversely if the annual is
entered, one monthly must be calculated (annual / 12).
Need the output to display BOTH the monthly & annual figures for the
inputter's one entry.
Will tip well for a timely answer.
Many thanks in advance!Is the data being entered into the same cell or is the option of two
cells/columns, labeled monthly expense and annual expense and then
convert from there for totals.The inputter enters the monthly expense in one column, or the annual
expense in another column. Need output cells that display monthly in
one column plus annually in the other.nrduncan-ga: 4 columns.cashindahat...
I have created a spreadsheet that I feel will meet your needs. The
user enters their expense in column A and then choose A for annual or
M for monthly in column B. If nothing is entered in column B, they
are instructed to choose one or the other. When the letter is
entered, the other columns then calculate appropriately. You may
notice that column F is hidden. This should remain hidden as this is
strictly where calculations take place and no need for the end-user to
see.
You can download the spreadsheet at http://www.freewebs.com/tarheelv/expenses.zip
Please let me know if you need any additional clarification.
-THV#If you have any other info about this subject , Please add it free.# |
|
