multiple IF's ?

  • Thread starter Thread starter foilprint0
  • Start date Start date
F

foilprint0

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 i
needed
if in 2A I put £10 3A would ad 45 days to 1A and display in 3A or 4A i
needed
if in 2A I put £20 3A would ad 30 days to 1A and display in 3A or 4A i
needed
if in 2A I put £40 3A would ad 20 days to 1A and display in 3A or 4A i
needed

can anyone give me an example of the code for cell 3A pleas
 
=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
 
Back
Top