Excel multiple functions in one cell
Closed
todd

May 3, 2010 at 10:18 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  May 3, 2010 at 10:44 AM
rizvisa1 Posts 4478 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
 Use two functions in one cell excel  Best answers
 How to add multiple functions in excel  Best answers
 Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓  Excel Forum
 Number to words in excel  Guide
 Marksheet in excel  Guide
 How to take screenshot in excel  Guide
 Excel free download  Download  Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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,""),""))))