|
| 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
August 28th 08, 04:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
August 28th 08, 04:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 28th 08, 04:37 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 28th 08, 04:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If formula with two conditions to meet
Sorry, I read that wrong. Try this.
IF(Z5>=0,IF(AB5>=3,1000,700),0)
|
|
#5
August 28th 08, 04:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 28th 08, 04:47 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If formula with two conditions to meet
Carol,
assuming numeric values version 1 when 300 is an add-on =(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
August 28th 08, 04:51 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If formula with two conditions to meet
forget version 2
-- regards, "driller" wrote: > Carol, > > assuming numeric values > > version 1 when 300 is an add-on > =(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
August 28th 08, 05:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 08: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 |
Linear Mode
