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 date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
