Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES
Hi,
I am tryng to create a conditional formula with two variables, each of one can have two values (exemple: if 0,5 day and 1 crew, then; if half day and two crew, then; if one day and one crew, then; if one day and two crew, then) , and I cannot find how to do it. can you please assist? Thanks Luis |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES
Need a better explanation.Try explaining something like this:
If A1 = 5 and B1 = 1, do this................ If A1 = 10 and B1 = 0, do this.............. etc etc Biff "luiss" wrote in message ... Hi, I am tryng to create a conditional formula with two variables, each of one can have two values (exemple: if 0,5 day and 1 crew, then; if half day and two crew, then; if one day and one crew, then; if one day and two crew, then) , and I cannot find how to do it. can you please assist? Thanks Luis |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES
Hi, thanks for your reply.
If A1 = 1 and B1 = 0,5 then C1 = 60; if A1 = 2 and B1 = 0,5 then C1 = 100; if A1 = 1 and B1 = 1, then C1 = 75; if A1 = 2 and B1 = 1, then C1 = 125. Thanks again for your assistance. Luis "Biff" wrote: Need a better explanation.Try explaining something like this: If A1 = 5 and B1 = 1, do this................ If A1 = 10 and B1 = 0, do this.............. etc etc Biff "luiss" wrote in message ... Hi, I am tryng to create a conditional formula with two variables, each of one can have two values (exemple: if 0,5 day and 1 crew, then; if half day and two crew, then; if one day and one crew, then; if one day and two crew, then) , and I cannot find how to do it. can you please assist? Thanks Luis |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES
luiss Wrote: Hi, thanks for your reply. If A1 = 1 and B1 = 0,5 then C1 = 60; if A1 = 2 and B1 = 0,5 then C1 = 100; if A1 = 1 and B1 = 1, then C1 = 75; if A1 = 2 and B1 = 1, then C1 = 125. Thanks again for your assistance. Luis [/color] Luis, this formula should be placed in C1. =IF(AND(A1=1; B1=0,5); 60; IF(AND(A1=2;B1=0,5); 100; IF(AND(A1=1;B1=1); 75; IF(AND(A1=2;B1=1); 125; "SOMETHING WRONG")))) HTH Kostis Vezerides -- vezerid ------------------------------------------------------------------------ vezerid's Profile: http://www.excelforum.com/member.php...o&userid=28481 View this thread: http://www.excelforum.com/showthread...hreadid=486047 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I use multiple nested functions? | Excel Worksheet Functions | |||
Can I use variables for workheet name references in Excel functions? | Excel Discussion (Misc queries) | |||
Can I use variables for workheet name references in Excel functions? | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions |