Ralphie8on
New Member
- Joined
- Jul 2, 2023
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I have a google Sheet with 2 tabs. The second tab is a giant 330 row table of data to be pulled into the first tab. In the first tab I have 30 rows that use the drop down to grab a name from the 2nd tab and fill out the rest of the row. I have attached the link to the doc and you can see what i mean on rows 28 - 57. I am trying to do a nested if statement in cell H20 that reads like this:
What i want is that cell to add what is in cell G2 with either 4, 3, 2, or 1 depending on if someone has selected Mighty of that version in the drop down.
https://docs.google.com/spreadsheet...OW-J-a8CDWRWa4zyR_136hxZU/edit?usp=drive_link
Excel Formula:
=If(A28:D57="Mighty 4",G2+4, if(A28:D57="Mighty 3", G2+3, if(A28:D57="Mighty 2", G2+2, if(A28:D57="Mighty 1", G2+1, G2))) )
What i want is that cell to add what is in cell G2 with either 4, 3, 2, or 1 depending on if someone has selected Mighty of that version in the drop down.
https://docs.google.com/spreadsheet...OW-J-a8CDWRWa4zyR_136hxZU/edit?usp=drive_link