Hello everyone again and thank you for all the support.
In one cell i will have a value and i would like to have another value in other cell based of the first one.
In A1 will be a number from 0 to 30 and i want in B1 to have like this:
If is 0 in A1 the value should be 300 in B1
If is 1 in A1 the value should be 200 in B1
If is 2 in A1 the value should be 150 in B1
If is 3 in A1 the value should be 100 in B1
And all values over 3 in A1 to be 0 in B1
Can be possible to be done with only one formula?
Thanks in advance.
In one cell i will have a value and i would like to have another value in other cell based of the first one.
In A1 will be a number from 0 to 30 and i want in B1 to have like this:
If is 0 in A1 the value should be 300 in B1
If is 1 in A1 the value should be 200 in B1
If is 2 in A1 the value should be 150 in B1
If is 3 in A1 the value should be 100 in B1
And all values over 3 in A1 to be 0 in B1
Can be possible to be done with only one formula?
Thanks in advance.