Formula help - Nested IF function?

[kidwispa]

Hi,

I was wondering if someone could help me with this formula. I have the following fields

Sales Value = Column A
Carrier Credit = Column B
Credit = Column C
Status = Column D
Amount = Column E

Here is what I'm trying to achieve:

1.If Column D says either "Rejected < £20.00" or "Rejected - Outside Agreed Timeframe" then it returns the value in Column C.

2. If Column D says anything other than the two things in point 1, AND column B is empty, then it returns the sum column C minus column A, otherwise it's column C minus column B.

I've been trying to figure this formula out for a few hours now so if anyone could help that would be great

Thanks

 

[Sandeep Warrier]

Assuming Row 1 has headers, how about

=IF(OR(D2="Rejected < £20.00",D2="Rejected - Outside Agreed Timeframe"),C2,IF(B2="",C2-A2,C2-B2))

 

[kidwispa]

Thanks Sandeep!