dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,352
- Office Version
- 365
- 2016
- Platform
- Windows
I have this formula: =IF(E5=Activities,U5, ((IF(OR(ISBLANK(A5),ISBLANK(D5),ISBLANK(E5)),0,[@[extra pickup]]+[@[$ 4 extra
hrs]]+[@[$ 4 kms]]+[@[Max
Pay]]))*[@[Staff '#]])*[10% increase])
I have an excel table (made using ctrl T) and I wanted the ability to add a custom amount in the total field without typing over and removing the formula. My formula works if I don't have IF(E5=Activities,U5, in the front but it doesn't allow me to add anything.
I have a text field that i can type the custom value and press a button that puts it in a column value of the table, U5, and I wanted that value to get put in the total field in place of the formula if a custom amount is required. I think my idea would work, I just needed help with the syntax.
hrs]]+[@[$ 4 kms]]+[@[Max
Pay]]))*[@[Staff '#]])*[10% increase])
I have an excel table (made using ctrl T) and I wanted the ability to add a custom amount in the total field without typing over and removing the formula. My formula works if I don't have IF(E5=Activities,U5, in the front but it doesn't allow me to add anything.
I have a text field that i can type the custom value and press a button that puts it in a column value of the table, U5, and I wanted that value to get put in the total field in place of the formula if a custom amount is required. I think my idea would work, I just needed help with the syntax.