Royalty Formula in Report

[marwan211]

I am a newbie to the forum but have worked with Access before. This formula is complicated (to me at least) and I would greatly appreciate some help. Here we go.


Field2: LICENSEA
Field3: LICENSEB
Field4: FEE
Field5: STATE
Field6: FEDERAL

Here is a word version of how I would like the formula to work:

if LICENSEA = 1, 20% of FEE goes to STATE and 80% goes to FEDERAL
if LICENSEA = 1 and LICENSEB = 1, 50% of FEE goes to STATE and 50% goes to FEDERAL

I'm extremely pressured to get this done and would be thankful for some guidance.

thx

 

[reclusivemonkey]

STATE: IIF(LICENSEA=1 AND LICENSEB=1,FEE*0.5,FEE*0.2)
FEDERAL: IIF(LICENSEA=1 AND LICENSEB=1,FEE*0.5,FEE*0.8)

If you have any other conditions, you will need to nest further, I.E.

IIF(LICENSEA=1 AND LICENSEB=1,FEE*0.5,IIF(LICENSEA=1,FEE*0.2,Null)