formula help needed please

[melissay]

I am trying to write a formula that will apply different rates if a certain cell is a Y or a N -----the 2 rates to apply are: *Focus Funds = 55% of AMF OR
**Architecture Funds = ("A std") + ( "A mgmt fee" x 20%)

 

[jproffer]

Well, not much to go on as far as ranges, etc. but I think you're talking about something like this maybe:

Excel 2013/2016
	A	B	C	D	E
1	YES or NO	A mgt fee	A Std	Your total	Type of funds
2	Y	$100.00	$50.00	$55.00	Focus Funds
3	N	$100.00	$50.00	$70.00	ArchFunds
Sheet1

Cell Formulas
Range	Formula
D2	=IF(A2="Y",B2*0.55,C2+(B2*0.2))
D3	=IF(A3="Y",B3*0.55,C3+(B3*0.2))
E2	=IF(A2="Y","Focus Funds","ArchFunds")
E3	=IF(A3="Y","Focus Funds","ArchFunds")

Are we close?

 

[melissay]

Perfect thanks a million

 

[jproffer]

You're very welcome. Glad it worked and thanks for the feedback.