IF statement

[Brian Thompmson]

I am trying to do an IF statement that works something
like:

if A2=1 then sum Sheet1 B5, if A2=2 then sum Sheet2 G5,
if A2=3 then sum Sheet3 G5

Any suggestions?

 

[Juan Sanchez]

Brian
=IF(A2=1,Sheet1!B5,IF(A2=2,Sheet2!G5,IF(A2=3,Sheet3!G5,0)))
Cheers
Juan

 

[Guest]

Worked like a charm! Thanks!

-----Original Message-----
Brian
=IF(A2=1,Sheet1!B5,IF(A2=2,Sheet2!G5,IF(A2=3,Sheet3! G5,0)))
.

 

[Juan Sanchez]

Glad to help

Cheers
Juan

-----Original Message-----
Worked like a charm! Thanks!
.