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)
I want it two display two possible loads to be used if the percentage is, for example, 77.5-80%
Is this possible?
Bookmarks