I used an IF statement in PowerPivot to generate some results but it stores it as a text column and not numeric.
=IF(AND([Staff Age]>17, [Staff Age]<28),"1","")
If I cannot change it to a numeric column how would I adjust the IF formula so that if it is True it generates a random number?
Aucun commentaire:
Enregistrer un commentaire