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
- Value in cell c77 - Best answers
- Multiple excel functions in one cell - Best answers
- Number to words in excel - Guide
- Gif in excel - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- How to lasso multiple objects in photoshop - Guide
- Marksheet in excel - Guide
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
((B11-10.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)+((B11-10.02)*328),IF(b10>=10.03,IF(C10>=6.69,B10*328,""),""))))
((B11-10.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)+((B11-10.02)*328),IF(b10>=10.03,IF(C10>=6.69,B10*328,""),""))))