Here's my problem. I have several long formulas that I need to adapt one by one in order to obtain the desired result. Here is an example of a formula using "IF" (which is "SI" in French).
=SI(C33=1;$TM$26;SI(C33=2;$TM$27;SI(C33=3;$TM$28;SI(C33=4;$TM$29;SI(C33=5;$TM$30;SI(C33=6;$TM$31;SI(C33=7;$TM$32;SI(C33=8;$TM$33;SI(C33=9;$TM$34;SI(C33=10;$TM$35;SI(C33=11;$TM$36;SI(C33=12;$TM$37;SI(C33=13;$TM$38;SI(C33=14;$TM$39;SI(C33=15;$TM$40;SI(C33=16;$TM$41;SI(C33=17;$TM$42;SI(C33=18;$TM$43;SI(C33=19;$TM$44;SI(C33=20;$TM$45;SI(C33=21;$TM$46;SI(C33=22;$TM$47;SI(C33=23;$TM$48;SI(C33=24;$TM$49;SI(C33=25;$TM$50;SI(C33=26;$TM$51;SI(C33=27;$TM$52;SI(C33=28;$TM$53;SI(C33=29;$TM$54;SI(C33=30;$TM$55;SI(C33=31;$TM$56;SI(C33=32;$TM$57;SI(C33=33;$TM$58;SI(C33=34;$TM$59;""))))))))))))))))))))))))))))))))))
In this fomula, I wish to modify all the "TM" into "UF" without having to manually change them one by one. Is there a speedy way to do this? Thanks!
Bookmarks