Excel formula AND

  • Thread starter Thread starter krù
  • Start date Start date
K

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
 
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
 
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
 
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.
 
Back
Top