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 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - 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 responses

vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
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 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
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