Excel multiple functions in one cell
Closed
todd

May 3, 2010 at 10:18 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  May 3, 2010 at 10:44 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  May 3, 2010 at 10:44 AM
Related:
 Two functions in one cell excel
 Excel two functions in one cell  Best answers
 Excel 2 functions in one cell  Best answers
 Multiple if function in one cell ✓  Forum  Excel
 Vba to copy and paste a range multiple times based on cell value ✓  Forum  Excel
 Duplicate rows multiple times based on cell value ✓  Forum  Excel
 How to duplicate rows x number of times  Forum  Excel
 Excel vba rename multiple sheets based on cell value  Forum  Excel
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
May 3, 2010 at 10:44 AM
May 3, 2010 at 10:44 AM
you have an extra closing bracket here
((B1110.02)*328))
Should be
=IF(B11+C11<=16.7,(16.7*0.6)*328,IF(B11<=10.02,(10.02*328),IF(B11>=10.03,(10.02*328)+((B1110.02)*328),IF(b10>=10.03,IF(C10>=6.69,B10*328,""),""))))
((B1110.02)*328))
Should be
=IF(B11+C11<=16.7,(16.7*0.6)*328,IF(B11<=10.02,(10.02*328),IF(B11>=10.03,(10.02*328)+((B1110.02)*328),IF(b10>=10.03,IF(C10>=6.69,B10*328,""),""))))