Multiple if conditions with result in one cell

[ROLAND.]

Hello,

How can I put the result, if possible in one cell/row. Here under what it should looks like when using multiple columns.
If amount is >100000 than the character "A" should appear.
If amount between 100000 and smaller than 50000 "B" should appear, etc...
<TABLE cellSpacing=0 cellPadding=2 width=552 border=0><TBODY><TR><TD width="16%" height=16>

Value​

​

​

​

</TD><TD width="14%" height=16>

>100000​

​

​

​

</TD><TD width="28%" height=16>

<100000 and >50000​

​

​

​

</TD><TD width="27%" height=16>

<50000 and >10000​

​

​

​

</TD><TD width="14%" height=16>

<10000​

​

​

​

</TD></TR><TR><TD width="16%" height=16>

120.000,00​

​

</TD><TD width="14%" height=16>

A​

​

</TD><TD width="28%" height=16>
</TD><TD width="27%" height=16>
</TD><TD width="14%" height=16>
</TD></TR><TR><TD width="16%" height=16>

30.000,00​

​

</TD><TD width="14%" height=16>
</TD><TD width="28%" height=16>
</TD><TD width="27%" height=16>

C​

​

</TD><TD width="14%" height=16>
</TD></TR><TR><TD width="16%" height=16>

2.000,00​

​

</TD><TD width="14%" height=16>
</TD><TD width="28%" height=16>
</TD><TD width="27%" height=16>
</TD><TD width="14%" height=16>

D​

​

​

</TD></TR></TBODY></TABLE>

Thanks in advance for your help

Roland

 

[lenze]

For one cell

=IF(A2>=100000,"A",IF(A2>=50000,"B",IF(A2>=10000,"C","D")))

lenze

 

[SteveO59L]

See if you can follow the logic of,


=if(a2>=100000,"A",if(a2>=50,000,"B",if(a2>=10,000,"C","D")))

 

[ROLAND.]

See if you can follow the logic of,


=if(a2>=100000,"A",if(a2>=50,000,"B",if(a2>=10,000,"C","D")))

Thanks a lot, it does the job

Roland