EXCEL FORMULA

Solved/Closed
AlainSatori
Posts
2
Registration date
Monday November 23, 2015
Status
Member
Last seen
November 25, 2015
- Nov 23, 2015 at 12:08 PM
vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
- Nov 25, 2015 at 10:57 PM
Hello,

I'm trying to do a formula like:

If value of celA3=sunday, then write dimanche

Any help would be appreciated.

thanks

3 replies

vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
249
Nov 24, 2015 at 11:22 PM
Hello Alain,

It seems that you would like the French word for Sunday in B3, so place the following formula in B3:-

=IF(A3="","",IF(A3="Sunday","Dimanche"))

I hope that this helps.

Cheerio,
vcoolio.
2
AlainSatori
Posts
2
Registration date
Monday November 23, 2015
Status
Member
Last seen
November 25, 2015
2
Nov 25, 2015 at 09:17 AM
Thank you so much, with your help I managed to create exactly what I was looking for ....here is the formula:

=IF(Data!B3="","",IF(Data!B3="Sunday","Dimanche",IF(Data!B3="Monday","Lundi",IF(Data!B3="Tuesday","Mardi",IF(Data!B3="Wednesday","Mercredi",IF(Data!B3="Thursday","Jeudi",IF(Data!B3="Friday","Vendredi",IF(Data!B3="Saturday","Samedi"))))))))
2
vcoolio
Posts
1347
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
June 10, 2022
249
Nov 25, 2015 at 10:57 PM
Hello Alain,

Well done! You've worked out how to create a nested IF formula.

Glad I could help out.

Cheerio,
vcoolio.
2