Previous Topic Next Topic

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 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - 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

Answer 1 / 3
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
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
Answer 2 / 3
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
Answer 3 / 3
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response