If function with 3 outcomes. As well as 2nd IF function to factor positive or negitive

**Danimal615** · 02-05-2013, 02:07 PM

Sorry but i was looking at the other change i need to make currently it is

=IF(Information!B26="n",1500,-1500)

So it shows as a buyers charge or credit. But i am trying to change this with the loan amount. So 1500 or -1500 for a loan of under 199999.99, 1700 or -1700 for loans over 200000, and 1800 or -1800 for loans above 300000. The cell showing the loan amount is D16. Is this possible or is it too many ifs?

**alansidman** · 02-05-2013, 02:15 PM

=if(and(Information!B26="n",D16<200000),1500,if(and(Information!B26<>"n",D16<200000),-1500,if(and(Information!B26="n",D16>=200000,D16<300000),1700,if(and(Information!B26<>"n",D16>200000,D16<300000),-1700,if(and(Information!B26="n",D16>=300000),1800,if(and(Information!B26<>"n",D16>300000),-1700,""))))))

Try the above

**Danimal615** · 02-05-2013, 02:18 PM

It is working for below 199kand below 299k, 300k and up is showing a blank cell

**Danimal615** · 02-05-2013, 02:31 PM

Sorry, it looks right when the answer is n, but when it is y it is blank

When Y, 300000 is blank, but anything else over 300 (such as 301000) is showing the -1700....any ideas?

**Danimal615** · 02-05-2013, 02:36 PM

I just changed it slightly incase anyone else needed to know. Thanks again for all the help

=IF(AND(Information!B26="n",D16<200000),1500,IF(AND(Information!B26<>"n",D16<200000),-1500,IF(AND(Information!B26="n",D16>=200000,D16<300000),1700,IF(AND(Information!B26<>"n",D16>200000,D16<300000),-1700,IF(AND(Information!B26="n",D16>=300000),1800,IF(AND(Information!B26<>"n",D16>=300000),-1800,""))))))