D

#### diablo

formula I'm using is as follows;

=IF((AND(H15="Capitol",I15="both")),F15/2,),IF((AND(H15="Capitol",I15="MPL41")),F15,)

Cell H15 does equal Capitol, Cell I15 does equal both, Cell F15 does

equal $3,094.36. When I use this formula I get the correct answer of

$1,547.18

=IF((AND(H15="Capitol",I15="both")),F15/2,)

When I try to nest another IF as shown above I get the error #value!.

By adding the IF((AND(H15="Capitol",I15="MPL41")),F15,) I want to

create a second condition for when I15 changes it's value to "MPL41".

What am I doing wrong?

Thanks,

Brian