If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




If formula with two conditions to meet
I have the following scenario:
If the value in cell Z5 is equal or greater than "0" the person gets $700 AND if in addition field value in cell AB5 reflects a number equal or greater than "3" then person gets $700 + 300 for a total of $1000 How should I compose the IF formula on cell O5? Any help with be much appreciated. Thanks. Carolina 
Ads 
#2




If formula with two conditions to meet
On Aug 28, 10:31 am, Carolina >
wrote: > I have the following scenario: > > If the value in cell Z5 is equal or greater than "0" the person gets $700 > AND > if in addition field value in cell AB5 reflects a number equal or greater > than "3" then person gets $700 + 300 for a total of $1000 > > How should I compose the IF formula on cell O5? > > Any help with be much appreciated. > > Thanks. > Carolina IF(AB5>=3,1000,IF(AB5>=0,700,0)) 
#3




If formula with two conditions to meet
Look in the help index for
AND  Don Guillett Microsoft MVP Excel SalesAid Software "Carolina" > wrote in message ... >I have the following scenario: > > If the value in cell Z5 is equal or greater than "0" the person gets $700 > AND > if in addition field value in cell AB5 reflects a number equal or greater > than "3" then person gets $700 + 300 for a total of $1000 > > How should I compose the IF formula on cell O5? > > Any help with be much appreciated. > > Thanks. > Carolina > > 
#4




If formula with two conditions to meet
Sorry, I read that wrong. Try this.
IF(Z5>=0,IF(AB5>=3,1000,700),0) 
#5




If formula with two conditions to meet
No IFs are needed:
=(Z5>=0)*(700+(AB5>=3)*300)  Gary''s Student  gsnu200802 "Carolina" wrote: > I have the following scenario: > > If the value in cell Z5 is equal or greater than "0" the person gets $700 > AND > if in addition field value in cell AB5 reflects a number equal or greater > than "3" then person gets $700 + 300 for a total of $1000 > > How should I compose the IF formula on cell O5? > > Any help with be much appreciated. > > Thanks. > Carolina > > 
#6




If formula with two conditions to meet
Carol,
assuming numeric values version 1 when 300 is an addon =(z5>=0)*700+300(ab5>=3) version 2 when z5 and ab5 must meet both criteria =(z5>0)*700+300(ab5>=3)  regards, "Carolina" wrote: > I have the following scenario: > > If the value in cell Z5 is equal or greater than "0" the person gets $700 > AND > if in addition field value in cell AB5 reflects a number equal or greater > than "3" then person gets $700 + 300 for a total of $1000 > > How should I compose the IF formula on cell O5? > > Any help with be much appreciated. > > Thanks. > Carolina > > 
#7




If formula with two conditions to meet
forget version 2
 regards, "driller" wrote: > Carol, > > assuming numeric values > > version 1 when 300 is an addon > =(z5>=0)*700+300(ab5>=3) > > version 2 when z5 and ab5 must meet both criteria > =(z5>0)*700+300(ab5>=3) > >  > regards, > > > > "Carolina" wrote: > > > I have the following scenario: > > > > If the value in cell Z5 is equal or greater than "0" the person gets $700 > > AND > > if in addition field value in cell AB5 reflects a number equal or greater > > than "3" then person gets $700 + 300 for a total of $1000 > > > > How should I compose the IF formula on cell O5? > > > > Any help with be much appreciated. > > > > Thanks. > > Carolina > > > > 
#8




If formula with two conditions to meet
Worked wonderfully! Thanks.
"Spiky" wrote: > Sorry, I read that wrong. Try this. > > IF(Z5>=0,IF(AB5>=3,1000,700),0) > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Counting rows that meet conditions in multiple columns  belleinhell  Excel Worksheet Functions  3  July 21st 08 06:50 PM 
count pieces of records meet conditions in different columns  Amy  Excel Worksheet Functions  1  July 19th 07 10:39 AM 
Array to meet conditions  Erin  Excel Worksheet Functions  5  January 16th 07 09:37 PM 
Hiding rows that meet multiple conditions in excel  KBV  Excel Discussion (Misc queries)  1  July 4th 06 10:14 PM 
counting cells in a data range that meet 3 specific conditions  bekah7  Excel Discussion (Misc queries)  3  October 1st 05 06:21 AM 