I'm having trouble with my formulas. I'm trying to get excel to autopopulate
certain cells with information using IF statements however I also need to
imbed OR statements otherwise the information isn't autopopulated correctly.
For example:
If A2=L and A3=L then A1 goes into cell B5 OR if B2=L and B3=L then B1 goes
into cell B5.
So what I need is a statement that'll allow me to use IF, AND and OR
statements all at the same time.
Can anyone give me a forumla that'll work? Can excel even do this?
Thanks.