LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

luiss - 17 Nov 2005 21:00 GMT

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

Reply to this Message

Biff - 17 Nov 2005 23:06 GMT

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

> Hi,
>
[quoted text clipped - 7 lines]
>
> Luis

Reply to this Message

luiss - 18 Nov 2005 08:38 GMT

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

> Need a better explanation.Try explaining something like this:
>
[quoted text clipped - 16 lines]
> >
> > Luis

Reply to this Message

vezerid - 18 Nov 2005 16:08 GMT

luiss Wrote:

> Hi, thanks for your reply.
>
[quoted text clipped - 8 lines]
>
> >[/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

Signature

vezerid

Reply to this Message