Posts by Vinicius • 215 points
4 posts
-
4
votes2
answers4592
viewsQ: How do you turn a comma number into an R?
I have a csv file, saved via Excel (using ";" as column separator). When I import it into the R the numbers that are in the 0.00 format are as factor and comma. Ex: "123,45" When making the…
-
3
votes1
answer663
viewsQ: How to remove spaces in a text without turning it into a number?
I have some codes that at the time of conversion to excel, appear several spaces and need to remove them via vba, but when I use the function Trim the same converts them into number instead of…
-
3
votes1
answer81
viewsQ: Why create a table in Mysql?
I’m learning to work with Mysql and I’m seeing some examples of how to work with more than one table, as an example below: Id Nome Faculdade_id 101 Amanda 11 102 Bianca 12 103 Carla 13 104 Daniela…
-
1
votes2
answers516
viewsA: Function IF Nested?
If I understand correctly, it’ll stay that way. =SE(E(G6>=20;G6<=30);100;SE(E(G6>30;G6<=40);200;SE(E(G6>40;G6<=50);300;SE(E(G6>50;G6<=60);400)))) Remembering that in the case…