if formula

[jaypee]

i have this formula in a cell D3 =IF(A1="F",B1&B2)
how can i make it multiple for example i want to add this IF(a2="G",B1&B3)
in D3 also.

thanks

 

[Bill Ridgeway]

Either -
=IF(AND(A1="F",A2="G"),B1&B3,)
=IF(OR(A1="F",A2="G"),B1&B3,)

Regards.

Bill Ridgeway
Computer Solutions

 

[Roger Govier]

Hi

IF(A1="F",B1&B2,IF(A1="G",B1&B3,""))
I assumed you meant A1 in each case, not A2 in the second case,
otherwise what do you do if A1="F" and A2="G"
My formula also assumes that you want null or "" if neither case is
satisfied, otherwise change the final condition to what you wish to see
in that event.

 

[Guest]

My guess.......

=IF(AND(A1="f",A2="g"),B1&B3,IF(A1="f",b1&B2,""))

Vaya con Dios,
Chuck, CABGx3