| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple IF's ?
Hi I have gone blank! in 1A I have a date of a purchase say 02/02/06 in 2A I have the amount invested Say £5 in 3A I want to have the maturity date Maturity date is dependant on amount of investment £5 = 65 days £10 = 45 days £20 = 30days £40 = 20 days Example: if in 2A I put £5 3A would ad 65 days to 1A and display in 3A or 4A if needed if in 2A I put £10 3A would ad 45 days to 1A and display in 3A or 4A if needed if in 2A I put £20 3A would ad 30 days to 1A and display in 3A or 4A if needed if in 2A I put £40 3A would ad 20 days to 1A and display in 3A or 4A if needed can anyone give me an example of the code for cell 3A please -- foilprint0 ------------------------------------------------------------------------ foilprint0's Profile: http://www.excelforum.com/member.php...fo&userid=6245 View this thread: http://www.excelforum.com/showthread...hreadid=506803 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple IF's ?
=IF(A1=40,"20 days",IF(A1=20,"30 days",IF(A1=10,"45 days",IF(A1=5,"65
days","")))) Vaya con Dios, Chuck, CABGx3 "foilprint0" wrote: Hi I have gone blank! in 1A I have a date of a purchase say 02/02/06 in 2A I have the amount invested Say £5 in 3A I want to have the maturity date Maturity date is dependant on amount of investment £5 = 65 days £10 = 45 days £20 = 30days £40 = 20 days Example: if in 2A I put £5 3A would ad 65 days to 1A and display in 3A or 4A if needed if in 2A I put £10 3A would ad 45 days to 1A and display in 3A or 4A if needed if in 2A I put £20 3A would ad 30 days to 1A and display in 3A or 4A if needed if in 2A I put £40 3A would ad 20 days to 1A and display in 3A or 4A if needed can anyone give me an example of the code for cell 3A please -- foilprint0 ------------------------------------------------------------------------ foilprint0's Profile: http://www.excelforum.com/member.php...fo&userid=6245 View this thread: http://www.excelforum.com/showthread...hreadid=506803 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move multiple rows of data that are not sequential | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
Linear Mode
