having a little problem writing right IF/THEN formula. Maybe you could me help with this one. A1 is "random" number from 0 to >1. B1 can have 5 different meanings, if A1 <0,25; 0,25-0,5; 0.5-0.75; 0.75-1.0 and >1.0 than it will have different name. Question is, how to set B1 to change its name according to "randomly" generated A1 value? For example if A1 is 0,785 than B1 should choose name 4. Thanks in advance!
Aucun commentaire:
Enregistrer un commentaire