Trying to build off an exisitng formula

[kcgojnur]

Hello -

I have the following formula

=ROUND(IF(F$21=TRUE,$T$13*(MAX((F43-$C$78),($C$59))+($C$61))*$C$60,0),0)

F43 is the annual premium
C78 is the subsidy amount
C59 is the minimum
C61 is the surcharge
C60 monthly pay frequency

I need to add the following logic to the max formula if C71 = "Aetna" than use C58 as the annual premium, if not no impact.
So basically if C71 is true C58+C61 * C60, otherwise I would need the above to apply.

 

[mrshl9898]

Like this?

=IF(C71="Aetna",(C58+C61)*C60,ROUND(IF(F$21=TRUE,$T$13*(MAX((F43-$C$78),($C$59))+($C$61))*$C$60,0),0))

 

[Ingolf]

Cross posting at:

https://www.excelforum.com/excel-general/1203606-trying-to-build-off-an-exisitng-formula.html

 

[kcgojnur]

Like this?

=IF(C71="Aetna",(C58+C61)*C60,ROUND(IF(F$21=TRUE,$T$13*(MAX((F43-$C$78),($C$59))+($C$61))*$C$60,0),0))

No this doesn't work.