Related:
- EXCEL FORMULA
- @ in excel formula ✓ - Forum - Excel
- Excel formula bar missing - How-To - Excel
- Excel formula to transfer data between worksheets - How-To - Excel
- Excel formula copy rows based on criteria ✓ - Forum - Excel
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
3 replies
vcoolio
- Posts
- 1292
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- May 7, 2021
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.
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.
AlainSatori
- Posts
- 2
- Registration date
- Monday November 23, 2015
- Status
- Member
- Last seen
- November 25, 2015
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"))))))))
=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"))))))))
Subscribe To Our Newsletter!
DON'T MISS
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- Computer Boots to Black Screen
- How to Get Free Diamonds in Free Fire
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Create a Gmail Account
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- How to Get More Followers on Instagram