dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,375
- Office Version
- 365
- 2016
- Platform
- Windows
Can someone help me with this function, I am trying to remove the RoundDown feature from the formula but it is not liking the brackets that I am removing. How should it look?
The formula is
Thanks,
Dave
The formula is
Code:
=IF([@Service]="Activities",ROUNDDOWN([@Activities],2),ROUNDDOWN(((IF(OR(ISBLANK(A11),ISBLANK(C11),ISBLANK(B11)),0,[@[extra pickup]]+[@[$ 4 extra
hrs]]+[@[$ 4 kms]]+[@[Max
Pay]]))*[@[Staff '#]]*[10%Increase]),2))
Thanks,
Dave