Log In
Register
Home
January 24, 2023
Offline
Hi All,
I have copied a simple if formula (it works) but I need to know how, if at all, I can/could change it to English and what the Foreign Language means.
=IF(DaySet=1, IF(WEEKDAY (DATE(Yearset, MONTH (TanggalAwal),1)) = 1, DATE((Yearset, MONTH(TanggalAwal),1),""), IF (WEEKDAY (DATE(Yearset, MONTH(TanggalAwal) ,1)) = 2 ,DATE((Yearset, MONTH(TanggalAwal) ,1) ,"").
Thanks
See Answer
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Check in the name manager and you should find the names and their references there. You can rename those, the names will be updated in the formulas as well.
Br,
Anders
Answers Post
Trusted Members
October 17, 2018
Offline
I don't think it's the formula the OP is interested in but in what the names it's refering to.
I would suggest, if the user has the file to list all named ranges and the address it refers to.
Excel in any language will not know what the user means with someting like 'TanggalAwal'. Google translate will probably be at loss there too
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Translations is not really an Excel issue, but anyway. The different translation services on the web says that tanggal awal is start date in the Indonesian language.
Br,
Anders
1 Guest(s)
