Excel IF help
Closed
murock
Posts
1
Registration date
Saturday 8 February 2014
Status
Member
Last seen
8 February 2014
-
8 Feb 2014 à 07:21
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Feb 2014 à 11:42
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Feb 2014 à 11:42
Related:
- Excel IF help
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Vat calculation excel - Guide
- Transfer data from excel to excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
10 Feb 2014 à 11:42
10 Feb 2014 à 11:42
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
