If there is value in one column then a $ generates in another
Closed
KiwiJess
Posts
1
Registration date
Thursday June 6, 2013
Status
Member
Last seen
June 6, 2013
-
Jun 6, 2013 at 11:06 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 10, 2013 at 10:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jun 10, 2013 at 10:46 AM
Related:
- If there is value in one column then a $ generates in another
- Generate unique id in excel ✓ - Excel Forum
- Excel copy column from one sheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
- Auto serial number in excel based on another column ✓ - Excel Forum
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jun 10, 2013 at 10:46 AM
Jun 10, 2013 at 10:46 AM
Hi KiwiJess,
Column H would contain:
=IF(G2="Single Hire",40,120)
Best regards,
Trowa
Column H would contain:
=IF(G2="Single Hire",40,120)
Best regards,
Trowa