B
Boris
Hello,
I have this problem to solve:
in A1 is int number from 0 to 6
in B1 is a value 1000
there is a separate table with "limits" such as
limit
0 100
1 200
2 300 etc to 6
in D should be formula which subtracts from 1000 a limit depending on what
is in A1.
Is there a sort of "case" function which will prevent of using dozen IFs on
this?
10x in advance
Boris
I have this problem to solve:
in A1 is int number from 0 to 6
in B1 is a value 1000
there is a separate table with "limits" such as
limit
0 100
1 200
2 300 etc to 6
in D should be formula which subtracts from 1000 a limit depending on what
is in A1.
Is there a sort of "case" function which will prevent of using dozen IFs on
this?
10x in advance
Boris