Previous Topic Next Topic

IF FORMULAR HELP PLEASE

Closed
excel - 11 Mar 2010 à 09:17
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Mar 2010 à 09:50
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
11 Mar 2010 à 09:50
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