Excel formulasini qanday o'zgartirish mumkin

enter image description hereHow to change cell ( I73) to formula (= D2 ) where D should be constant and 2 be varying according input from cell M57 ? I have trying to write as ="D" & M57 .

2
= Indirect ("D" va M57) harakat qilib ko'ring
qo'shib qo'ydi muallif Doug Glancy, manba
Dag Glancy juda chinakamiga baxtiyorman
qo'shib qo'ydi muallif Binod Thakur, manba

7 javoblar

Sizga "Ushbudan bo'lmagan" funktsiyasidan foydalanadigan Dag Glancy dan bir izoh berilgan.

=INDIRECT("D" & M57)

Indeksni ishlatadigan uchqun bo'lmagan yechim quyidagilar:

=INDEX($D:$D, M57)
1
qo'shib qo'ydi
Yup, bu yaxshiroq bo'lar edi.
qo'shib qo'ydi muallif Doug Glancy, manba

Sizga "Ushbudan bo'lmagan" funktsiyasidan foydalanadigan Dag Glancy dan bir izoh berilgan.

=INDIRECT("D" & M57)

Indeksni ishlatadigan uchqun bo'lmagan yechim quyidagilar:

=INDEX($D:$D, M57)
1
qo'shib qo'ydi
Yup, bu yaxshiroq bo'lar edi.
qo'shib qo'ydi muallif Doug Glancy, manba

enter image description hereEg: this is formula double click on it

formulani tahrir qilish uchun unga ikki marta bosing ...

1
qo'shib qo'ydi

enter image description hereEg: this is formula double click on it

formulani tahrir qilish uchun unga ikki marta bosing ...

1
qo'shib qo'ydi

The Image Shows you can you can edit formula by two ways by edit formula bar and edit on your formula row by double clicking This is showing tour solution..

1
qo'shib qo'ydi

The Image Shows you can you can edit formula by two ways by edit formula bar and edit on your formula row by double clicking This is showing tour solution..

1
qo'shib qo'ydi

Ikkita yoki undan ortiq matn satrini bitta satrga birlashtirish uchun CONCATENATE dan foydalaning. Siz shunday foydalanishingiz mumkin:

=CONCATENATE("D",M57)

Qo'shimcha ma'lumot

0
qo'shib qo'ydi