Excel IF help
Closed
murock
Posts
1
Registration date
Saturday February 8, 2014
Status
Member
Last seen
February 8, 2014
-
Feb 8, 2014 at 07:21 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 10, 2014 at 11:42 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 10, 2014 at 11:42 AM
Related:
- Excel IF help
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 10, 2014 at 11:42 AM
Feb 10, 2014 at 11:42 AM
Hi Murock,
It is not possible to put a value and a formula in one cell.
You could use a macro but the most common way is to use an extra column.
Formula would look like:
=IF(B1="Tom",C1+D1,C1)
In addition you can choose to hide column C if you don't want to see it.
Best regards,
Trowa
It is not possible to put a value and a formula in one cell.
You could use a macro but the most common way is to use an extra column.
Formula would look like:
=IF(B1="Tom",C1+D1,C1)
In addition you can choose to hide column C if you don't want to see it.
Best regards,
Trowa
