Can't seem to get the formula right. if a specific cell is "Team a" copy the formula in K18 -- if that same cell is "Team 2" copy the formula from K19. I came up with =IFS(A17= "Team 1",K18, A17= "team 2",K19) But my old version of Excel does not have IFS. (not sure if it is correct anyhow) Is there another way? thanks
Nested IF
=IF(A17= "Team 1",K18, IF(A17= "team 2",K19,""))
=IFS(A17="team 1",K18,A17="team 2",K19) Will work in later versions of Excel
Last edited by etaf; 01-06-2021 at 03:52 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you. I appreciate the help. worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks