Join text with numeric values that have division

[ozbeachbum]

Hi,
I am endeavouring to combine text with numeric values that have addition and division.
The following formula works with the addition,

=IF(D66>0,"03 $"&TEXT('Exp Pay Est'!AA86+'Exp Pay Est'!AA88,"000.00"),IF(D62+D64>0,"02 $"&TEXT('Exp Pay Est'!AA86+'Exp Pay Est'!AA88,"000.00"),""))

but when I add the division,

=IF(D66>0,"03 $"&TEXT('Exp Pay Est'!AA86+'Exp Pay Est'!AA88)/3,"000.00"),IF(D62+D64>0,"02 $"&TEXT('Exp Pay Est'!AA86+'Exp Pay Est'!AA88)/2,"000.00"),""))

I receive an error message, To Few Arguments.
I have tried numerous bracketing options but have had no success.
Any assistance would be greatly appreciated.
Cheers,
Dave.

 

[Alex Blakenburg]

Try adding an additional "(" after both ocurrences of TEXT

=IF(D66>0,"03 $"&TEXT(('Exp Pay Est'!AA86+'Exp Pay Est'!AA88)/3,"000.00"),IF(D62+D64>0,"02 $"&TEXT(('Exp Pay Est'!AA86+'Exp Pay Est'!AA88)/2,"000.00"),""))

 

[Rick Rothstein]

What are you trying to divide by the 3 or the 2... the entire summation or the last term in the summation? If the entire summation, then Alex is correct, you have to add an opening parenthesis after each TEXT function name to balance the parenthesis you included in front of your division sign (the slash). If, on the other hand, you are only trying to divide the last term of the summation, just omit the parenthesis in front of the division signs.

 

[ozbeachbum]

Try adding an additional "(" after both ocurrences of TEXT

=IF(D66>0,"03 $"&TEXT(('Exp Pay Est'!AA86+'Exp Pay Est'!AA88)/3,"000.00"),IF(D62+D64>0,"02 $"&TEXT(('Exp Pay Est'!AA86+'Exp Pay Est'!AA88)/2,"000.00"),""))

Thank you greatly appreciated.

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.