I am building a little bit of a database. I need help with getting a formula that will give me the correct values based on wins and loses.
IIf([Money Line]>0,(IIf([W/L]="W",[Amount Wagered]*[Money Line],[Amount Wagered]*(-1))),(IIf([W/L]="W",([Amount Wagered]/[Money Line])*(-1),[Amount Wagered]*1)))
Im not sure where I went wrong and its hurting my head. Thanks for your time.
IIf([Money Line]>0,(IIf([W/L]="W",[Amount Wagered]*[Money Line],[Amount Wagered]*(-1))),(IIf([W/L]="W",([Amount Wagered]/[Money Line])*(-1),[Amount Wagered]*1)))
Im not sure where I went wrong and its hurting my head. Thanks for your time.