Excel formula AND

[krù]

Hi everybody!
I need to link 2 condition in the same formula and I don't kno
whether can I use the AND formula or not.

The formula I used is this:

=IF($G$4=1;GT!C121;IF($G$A=2;GT!C122;IF($G$4=3;GT!C123)))

and it works ok!

Now, I would like to link another condition, that is in words, if G4=
and D4=1 then GT!C121 etc...

How can I do this, if it is possible?

Thank you!

Cia

 

[Frank Kabel]

Hi
try
=IF(AND($G$4=1,$D$4=1);GT!C121;IF($G$A=2;GT!C122;IF
($G$4=3;GT!C123)))

 

[Don Guillett]

Did you look in HELP index for AND?

 

[krù]

Yes, I did, but I'm not able to understand how it works really well.

Can you help me?

Plus: is there a way to nest more than 7 function together?

Thanks

Kr

 

[Frank Kabel]

Hi
for using AND see my previous response. If you need more
than 7 conditions you may change the approach
- use a lookup table and VLOOKUP
- apply a mathematical algorithmn if possible.

So if you could explain the complete set of your
conditions there may be better solutions

 

[Norman Harker]

Hi krù!

AND as function can stand on its own:

=AND(A1=7,A2="m")

This returns TRUE if both / all conditions are met and FALSE if either
/ any of the conditions are not met.

As such, recalling that an IF function requires as the first answer, a
condition that must return TRUE or FALSE, we can use the AND function
as a condition in an IF function:

=IF(AND(A1=7,A2="m"),"7 year old male","not 7 year old male")

Regarding your "Plus: is there a way to nest more than 7 function
together?"

Yes! But most often we would use some other method of achieving the
desired result. Here, we'd most often use VLOOKUP or another look up
function.

 

[krù]

Thank you very much, Norman!

Ciao
Kr