IF formula needed
Closed
modemers
Posts
2
Registration date
Wednesday 25 January 2017
Status
Member
Last seen
25 January 2017
-
25 Jan 2017 à 12:18
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 26 Jan 2017 à 11:12
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 26 Jan 2017 à 11:12
Related:
- IF formula needed
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
- Number to words in excel formula - Guide
- Formula spreadsheet definition - Guide
- Date formula in excel dd/mm/yyyy - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
25 Jan 2017 à 12:36
25 Jan 2017 à 12:36
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 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
26 Jan 2017 à 11:12
26 Jan 2017 à 11:12
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
25 Jan 2017 à 14:48
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.