ozbeachbum
Board Regular
- Joined
- Jun 3, 2015
- Messages
- 161
- Office Version
- 2021
- Platform
- Windows
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.
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.