PDA

View Full Version : Formula



Dawied
15th March 2012, 03:15 AM
Good day
There seems to be a problem on the bets page, the payout column does not show any figures. All the required fields are completed but it does not update the payout.
I followed the advice on how to reset the formulas but it still does not work. This is version 2.01 and excel 2007 onwards.
=ROUND(IF(O11>0;IF(M11="Y";AW11*(1-O11);IF(AW11>R11;R11 + (AW11 - R11)*(1-O11);AW11));AW11);ROUNDING

Can anyone help please.:confused:

admin
15th March 2012, 09:20 AM
Hi,

The easiest way for me to diagnose the problem is to look at your copy of the spreadsheet. I will send you a PM.