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

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