A Mod at office 365 said to post this hear as the code would be the same.

Hi All



Looking for a little help with a formula on a calculated collum in a custom list that is used as a profit and loss chart, the formula below should calculate the amount 'Cal' is paid, the bit i'm having trouble with is since I included that cal should only be paid if '[Worked By Cal]' results yes.



=IF([Worked by Cal]="Yes","Yes",IF([Worked by Cal]="","[Total Revenue]*5/100+[Cal Hours]*10+50"))



I'm not a whiz by any means with formula so your help would be greatly appreciated.



Many Thanks

Jake