IF conditional formula

[Prajwal19]

Hi Everyone,

I need help to build the formula for below data - 

Investor	Closing Gross	HWM	Fee
A	100	95	20
A	96	45	10
A	100	56	20
B	95	95	64
A	85	90	20
A	86	80	10
C	90	85	16

If Investor = A and Closing Gross > HWM then (Closing Gross- HWM)*20% else

If Investor = B then sum of Total fee of Investor A *20% else

If Investor = C then sum of Total Fee of Investor A*80%

Thank you

[AbhilashR · Accepted solution]

Hi @Prajwal19, I put together a sample solution to compute your desired output. Please take a look and let us know if this addresses your question.

[Laurap1228]

Try the following solution

[Prajwal19]

Thank you Abhilash. Above solution worked.