IF(AND Function Question/help

[KasperSSI]

Hi,

I have my accounts in excel from 200000 to 499999 and i want to do an IF(AND function for cell A1 where i differentiate the output in Raw materials and services and so on.

The first step i can make work: =IF(AND(A1>200000,A1<300000);"Raw materials";"") This part works. But i want to do nested IF's so the same formula shows whether it is 200000-300000 (raw materials) or 300000-400000 (services) 400000 - 499999 (other services).

Is this possible?

Thank you in advance for your help

 

[DanteAmor]

Hi @KasperSSI, welcome to the forum!

Try this

Book1
	A	B
1
2	200000	Raw materials
3	300000	services
4	400000	other services
Sheet

Cell Formulas
Range	Formula
B2:B4	B2	=IF(A2<300000,"Raw materials",IF(A2<400000,"services","other services"))

Or this

=LOOKUP(A2,{200000,300000,400000},{"Raw materiales","services","other services"})

 

[KasperSSI]

Thank you for the suggestion, i very much appreciate it. Made it work by using:
=IF(AND(E2>200000;E2<300000);"raw";IF(AND(E2>300000;E2<400000);"serv";IF(AND(E2>400000;E2<500000);"other services";"")))

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.