Hey guys!
I'm a personal trainer, and I'm working on a training spreadsheet for a few of my clients to serve as a template.
What I have right now is an IF statement that calculates the load to be used based on a cells defined name.
The problem I'm encountering is that I have two possible percentages of the 1RM (one rep max) in several cells, thus resulting in a #VALUE error.
Formula is as follows:
It works if the percentage is fixed (70%,75%,80%,etc)![]()
=IF(D9="SQUAT",MROUND(SQMAX*I9,5),IF(D9="BENCH",MROUND(BNMAX*I9,5),IF(D9="DEADLIFT",MROUND(DLMAX*I9,5),)))
I want it two display two possible loads to be used if the percentage is, for example, 77.5-80%
Is this possible?
Bookmarks