Previous Topic Next Topic

IF FORMULAR HELP PLEASE

Closed
excel - Mar 11, 2010 at 09:17 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 11, 2010 at 09:50 AM
Hello,

I am having trouble getting something to work. I need to create a formular that will enter a certain percenatage for amounts that hit a certain criteria and another percentage if the amounts hit a different criteria, below is an example of a formular i have tried to use:

=IF(AG2<100,IF(X2>35,IF(X2<69.99,"0",IF(AG2>100,IF(X2>35,IF(X2<69.99,SUM(V2/100*1)))))))

Does anyone know how I can get this to work?

Many thanks in advance!

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 11, 2010 at 09:50 AM
Could you explain in words what conditions that you want to see. I dont think the if conditions that you have are right. Just reading two ifs i get this


if ag2<100 and x2>35 and x2 <69.99, then 0
if ag2 <100 and x2>35 and x2>=69.99 and ag2>100

Now of course you will never have ag2 <100 at the same time when ag2>100
0