EXCEL FORMULA
Solved/Closed
AlainSatori
vcoolio
- Posts
- 2
- Registration date
- Monday November 23, 2015
- Status
- Member
- Last seen
- November 25, 2015
vcoolio
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
Related:
- EXCEL FORMULA
- @ in excel formula ✓ - Forum - Excel
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
- How to ignore false in excel formula ✓ - Forum - Office Software
- Number to words in excel formula - Guide
- Excel formula to transfer data between worksheets - Guide
3 replies
vcoolio
Nov 24, 2015 at 11:22 PM
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
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.
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
Nov 25, 2015 at 09:17 AM
- Posts
- 2
- Registration date
- Monday November 23, 2015
- Status
- Member
- Last seen
- November 25, 2015
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"))))))))
=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"))))))))
vcoolio
Nov 25, 2015 at 10:57 PM
- Posts
- 1347
- Registration date
- Thursday July 24, 2014
- Status
- Moderator
- Last seen
- June 10, 2022
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.
Well done! You've worked out how to create a nested IF formula.
Glad I could help out.
Cheerio,
vcoolio.