# Thread: Complex If Problem (Excel 2000/2003)

1. ## Complex If Problem (Excel 2000/2003)

Hi

I am having a problem with what I percieve to be a complex IF Problem

I would be grateful for any help.

Thanks

2. ## Re: Complex If Problem (Excel 2000/2003)

- What should happen if Disp_Capital is less than or equal to 600 and Duration is 2 or 3?
- What should happen if Disp_Capital is greater than 600 and Duration is 1?

3. ## Re: Complex If Problem (Excel 2000/2003)

Hi Hans

- What should happen if Disp_Capital is less than or equal to 600 and Duration is 2 or 3? (Then Disp_Capital Should only appear in Year 1)
- What should happen if Disp_Capital is greater than 600 and Duration is 1? (Then Disp_Capital Should only appear in Year 1).

Many Thanks

4. ## Re: Complex If Problem (Excel 2000/2003)

Year 1: =IF(AND(disp_capital>600,duration>1),disp_capital/duration,IF(disp_capital>0,disp_capital,""))

Year2: =IF(AND(disp_capital>600,duration>1),disp_capital/duration,"")

Year3: =IF(AND(disp_capital>600,duration>2),disp_capital/duration,"")

5. ## Re: Complex If Problem (Excel 2000/2003)

Hi Hans

What can I say I am forever in your debt.

Grateful 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
•