syntax of an If formula

[dpaton05]

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.

 

[dpaton05]

The formula has the following syntax:

=IF(E5=”Activities”,U5,xxx)

Ignore the xxx, is there anything wrong with this if statement?

 

[fhqwgads]

maybe retype your quotations marks "" in your cell around Activities ?

 

[dpaton05]

Thanks.

 

[dpaton05]

How do I copy a text box to a cell with a command button?

 

[Michael M]

Nothing wrong with the syntax of the IF statement, assuming the xxxx is a cell reference !
Regarding the text box to cell macro....give us more detail on what you want to achieve.