thesproing
Board Regular
- Joined
- Jul 16, 2007
- Messages
- 76
Hi guys,
real quickie...
is there an easier way of writing....
=IF(B2=A,X,IF(B2=B,Y,IF(B2=C,Zetc......ect......ect........0)))))))))))))))) (lol)
where a, b, c etc are years eg 2005, 2006, 2007, and x, y and z are cell referances? i have bout 40 varriants and im lazy.
thanks.
real quickie...
is there an easier way of writing....
=IF(B2=A,X,IF(B2=B,Y,IF(B2=C,Zetc......ect......ect........0)))))))))))))))) (lol)
where a, b, c etc are years eg 2005, 2006, 2007, and x, y and z are cell referances? i have bout 40 varriants and im lazy.
thanks.