Formula help requested

KhGreen13

This one is testing my abilities and my patience!

If the Sharing Method is External, then Grant Amount is .25 of Expense or if the Sharing Method is Internal Only, then the Grant Amount is .45 of the Expense or if the Sharing Method is Specific Program, then the Grant Amount is .06 of the Expense.

Any help would be greatly appreciated. Thanks in advance!

heyjay

External	$210.00	52.5
Internal Only	$210.00	94.5
Specific Program	$210.00	12.6

=IF([Sharing Method]@row = "External", Expense@row * 0.25, 
IF([Sharing Method]@row = "Internal Only", Expense@row * 0.45, 
IF([Sharing Method]@row = "Specific Program", Expense@row * 0.06,
 "")))

heyjay

External	$210.00	52.5
Internal Only	$210.00	94.5
Specific Program	$210.00	12.6

=IF([Sharing Method]@row = "External", Expense@row * 0.25, 
IF([Sharing Method]@row = "Internal Only", Expense@row * 0.45, 
IF([Sharing Method]@row = "Specific Program", Expense@row * 0.06,
 "")))

KhGreen13

Thanks a million! I could not get the commas and the parentheses in the right places! Worked perfectly. Appreciate your speedy help!