IF formula needed
Closed
modemers
Posts
2
Registration date
Wednesday January 25, 2017
Status
Member
Last seen
January 25, 2017
-
Jan 25, 2017 at 12:18 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 26, 2017 at 11:12 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 26, 2017 at 11:12 AM
Related:
- IF formula needed
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jan 25, 2017 at 12:36 PM
Jan 25, 2017 at 12:36 PM
modemers, Good afternoon.
I'm sorry but your explanation is extremely confusing.
Try again by setting an example to make it easier for people to help you.
Surely someone will come to help you.
I'm sorry but your explanation is extremely confusing.
Try again by setting an example to make it easier for people to help you.
Surely someone will come to help you.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jan 26, 2017 at 11:12 AM
Jan 26, 2017 at 11:12 AM
Hi Modemers,
When column B contains the wages, column F contains the X's and for example column C contains the employee names then try this:
=SUM((B2:B5)*(C2:C5="Employee1")*(F2:F5="X"))
This is an array formula and need to be confirmed by hitting Ctrl+Shift+Enter.
When done correctly, the formula will be enclosed by curly brackets {}.
Best regards,
Trowa
When column B contains the wages, column F contains the X's and for example column C contains the employee names then try this:
=SUM((B2:B5)*(C2:C5="Employee1")*(F2:F5="X"))
This is an array formula and need to be confirmed by hitting Ctrl+Shift+Enter.
When done correctly, the formula will be enclosed by curly brackets {}.
Best regards,
Trowa
Jan 25, 2017 at 02:48 PM
Column B is a list of numbers (employee gross wages).
Column F is where the user will enter an "X" if that particular employee is participating in a certain program.
When the user marks the x in column F, I want that cell to carry over (=) the gross wages from column B.
BUT... I want the user to SEE the "X". (not the number carried over from column B)
Then I can autosum column F so that I get the total gross wages for the selected employees.
These are inexperienced users and if the cell DISPLAYS the gross wages instead of just the "X", they will think they messed something up.
I don't know if this is possible (to have a formula calculate a result but DISPLAY the original text.