davefaust78
New Member
- Joined
- Sep 11, 2017
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to get a nested IF(or formula to work depending on what's in a cell. My formula looks like this so far:
=IF(or((H5="Chest",INDEX(Chest,RANDBETWEEN(1,15),1),"Needs Workout"),(H5="Bodyweight",INDEX(Bodyweight,RANDBETWEEN(1,21),1))
If I remove the OR( part of the statement and just close it at the IF( the formula works just fine. I type "Chest" in cell H5 and I get a random value from my chest range. Once I try to now add-in the additional OR( argument is where I'm having the difficulty. The problem I'm having is closing the statement.
I included an image of my named ranges to show where the indexed lists reside.
This is for a weekly workout routine that randomizes the workouts depending on body part I want to do that day. Ideally, I'd also like to add-in other indexed lists I created for Arms, Legs, Core, etc.
I hope you can help.
Thank you,
Dave
I am trying to get a nested IF(or formula to work depending on what's in a cell. My formula looks like this so far:
=IF(or((H5="Chest",INDEX(Chest,RANDBETWEEN(1,15),1),"Needs Workout"),(H5="Bodyweight",INDEX(Bodyweight,RANDBETWEEN(1,21),1))
If I remove the OR( part of the statement and just close it at the IF( the formula works just fine. I type "Chest" in cell H5 and I get a random value from my chest range. Once I try to now add-in the additional OR( argument is where I'm having the difficulty. The problem I'm having is closing the statement.
I included an image of my named ranges to show where the indexed lists reside.
This is for a weekly workout routine that randomizes the workouts depending on body part I want to do that day. Ideally, I'd also like to add-in other indexed lists I created for Arms, Legs, Core, etc.
I hope you can help.
Thank you,
Dave