Home |
Search |
Today's Posts |
#1
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 |
#2
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
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
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
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
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 =(z50)*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
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 =(z50)*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
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting rows that meet conditions in multiple columns | Excel Worksheet Functions | |||
count pieces of records meet conditions in different columns | Excel Worksheet Functions | |||
Array to meet conditions | Excel Worksheet Functions | |||
Hiding rows that meet multiple conditions in excel | Excel Discussion (Misc queries) | |||
counting cells in a data range that meet 3 specific conditions | Excel Discussion (Misc queries) |