# Multiple if conditions with result in one cell

#### ROLAND.

##### New Member
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>

Roland

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
For one cell
Code:
``=IF(A2>=100000,"A",IF(A2>=50000,"B",IF(A2>=10000,"C","D")))``

lenze

Last edited:
See if you can follow the logic of,

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

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

Replies
19
Views
300
Replies
1
Views
129
Replies
1
Views
219
Replies
6
Views
113
Replies
1
Views
147

1,206,811
Messages
6,075,002
Members
446,113
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back