# Thread: multiple if statements (xp & 2003)

1. ## multiple if statements (xp & 2003)

I submitted a posting last week and was returned a answer that worked well. A slight change to the scenerio had come about. In the attached spreadsheet you will see that column B was added. the formula should read that if : cell A2 = "no" and if cell B2="m" then the formula should be (col E - Col D) times the ratio formula. However if cell A2 = "no" and if cell B2="a" then the formula should be (col E) times the ratio formula cell.

Also, is cells in column B did not have an "m" or "a" column H should state "M or A ?". Many Thanks

is this possible?

2. ## Re: multiple if statements (xp & 2003)

Does this do what you want (enter in H2, fill down)?

=IF(NOT(OR(B2="M",B2="A")),"M or A?",IF(A2&C2="","ERROR",IF(C2="","NO-DATE",IF(A2="","YES/NO",(ROUND((FYE_2008-C2)/366*IF(A2="NO",E2,G2),-1))))))

3. ## Re: multiple if statements (xp & 2003)

Or this? (I'm getting very confused)

=IF(NOT(OR(B2="M",B2="A")),"M or A?",IF(A2&C2="","ERROR",IF(C2="","NO-DATE",IF(A2="","YES/NO",(ROUND((FYE_2008-C2)/366*IF(A2="NO",IF(B2="M",E2-D2,E2),G2),-1))))))

4. ## Re: multiple if statements (xp & 2003)

I will give it a shot. Thanks

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•