Home » Forums » Open Source Learning Center » Question and Answer

Help with IF function

Submitted by bbecky1 on 5 June, 2014 - 13:05

Hi
I am using Excel 2010.

In A column the date something is received will be entered.
In B column there is a drop down list that has "insured" "Fee" "Aged Debt" "Other".
In C column I am trying to get another date to populate dependant on what is picked from column B, so if Insured is picked then 1 day needs to be added to the date in column A and populate in column C. If any of the other 3 options are selected 5 days needs to be added to the date in column A and populated in column C.

Everything I have tried has not worked so any help with the formula would be greatly appreciated :)

‹ Rectifying Charts or creating Charts in Excel 2010 - need help How to get weighted Average ? ›
»

Hi, Here is your formula

Submitted by Jon on 5 June, 2014 - 15:27.

=IF(B1="","",IF(B1="Insured",A1+1,A1+5))

Hope this helps

»

Sorry I am fairly new to

Submitted by bbecky1 on 5 June, 2014 - 19:32.

Sorry I am fairly new to excel...What would I need to add to the formula if it was 1 working day and 5 working days that I needed to add rather than just days?
Thanks Becky

»

Thanks so much :)

Submitted by bbecky1 on 5 June, 2014 - 15:45.

Thanks so much :)

»