Using Google Sheets.
I would like to change to use several conditions which results different values, and if nothing else did not match, then result other value.
In pseudo code:
A1 = 8
Set B1 If A1=1, then B1 result is 100,
If A1=4, then B1 result is 200,
If A1=6, then B1 result is 300,
If A1=10, then B1 result is 400,
Else B1 result is 0.
What formula is the most simplest way to describe this?