EXCEL FORMULA [Solved/Closed]

Report
Posts
2
Registration date
Monday November 23, 2015
Status
Member
Last seen
November 25, 2015
-
Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
-
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

Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
230
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Monday November 23, 2015
Status
Member
Last seen
November 25, 2015
2
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
230
Hello Alain,

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

Glad I could help out.

Cheerio,
vcoolio.
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!