Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text with a numeric funtion
I am very new to xl and am trying to create invoices for my business. And on
these invoices I have a terms list showing "On Reciept, Net 30, and 2% 10 Net 30." I also show a Invoice date and a due date. I would like to to be able to type in my invoice date then choose from my terms list and have it add the appropriate number to that date and show me my due date. for example Invoice Date 12/20/2007 Terms Net 30 from pop down menu.. i have already built the pop down list. By choosing Net 30 It adds 30 days to the above invoice date. With "On Receipt" it will add 0 etc. Due Date 01/19/2008 Is this possible? is it possible to have text with a numeric value. P.s I don't know lingo so if you could explain it to me in very simple terms that I can understand that would be great. Thank you for your help Ive been working on trying to find the solution for about 4 hours now. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text with a numeric funtion
I'm not sure about your "2% 10 Net 30" bit. Do you have just three
alternatives for your terms, of which "On receipt" adds 0 days and the other two add 30 days? If so, let's say the invoice date is in A1 and the terms (from your drop-down list) in B1. In the due date cell you could use a formula such as =A1+IF(B1="On receipt",0,30) (You need to format both date cells with a suitable date format.) We could extend this if there are further alternatives. Post back with details if you need more help. "Desperate for Help" <Desperate for wrote in message ... I am very new to xl and am trying to create invoices for my business. And on these invoices I have a terms list showing "On Reciept, Net 30, and 2% 10 Net 30." I also show a Invoice date and a due date. I would like to to be able to type in my invoice date then choose from my terms list and have it add the appropriate number to that date and show me my due date. for example Invoice Date 12/20/2007 Terms Net 30 from pop down menu.. i have already built the pop down list. By choosing Net 30 It adds 30 days to the above invoice date. With "On Receipt" it will add 0 etc. Due Date 01/19/2008 Is this possible? is it possible to have text with a numeric value. P.s I don't know lingo so if you could explain it to me in very simple terms that I can understand that would be great. Thank you for your help Ive been working on trying to find the solution for about 4 hours now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text to numeric | Excel Worksheet Functions | |||
text to numeric | Excel Discussion (Misc queries) | |||
Coverting text to numeric | Excel Worksheet Functions | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
Text to Numeric | Excel Worksheet Functions |