Integrating Multiple IF Formulae

[jrarmstrong]

Hi,

I have written the formula below but cannot get it to work. Each separate IF formula works on its own but when I cobine the two I Just get the "#VALUE!" message.

=IF(MyB!K2="F","L-IP",""),IF((MyB!K2="F")*AND(MyB!K3="F"),"CAN","")

If anyone has any suggestions I would appreciate it.

Thanks,

James

 

[Robert Mika]

Try:
=IF(AND(MyB!K2="F",MyB!K3="F"),"CAN",IF(MyB!K2="F","L-IP",""))

 

[jrarmstrong]

Thanks for the quick response Robert. Your suggestion works perfectly.

James