Coach_Olson
New Member
- Joined
- Jan 27, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi all,
I'm trying to get blank cells when referencing to another cell using IFERROR. When I do so I keep getting a zero and not a blank cell. For context, I'm a strength and conditioning coach using excel for program templates, the cell I'm referencing is the Max of the lift and the other cell is the percentage of that lift I want to prescribe. Here is my formula
=IFERROR(IF(ISBLANK($I16),MROUND($E16*$J16,5),MROUND($E16*$I16,5)&"-"&MROUND($J16*$E16,5)),"")
Any help would be great and appreciated! Thank you!
I'm trying to get blank cells when referencing to another cell using IFERROR. When I do so I keep getting a zero and not a blank cell. For context, I'm a strength and conditioning coach using excel for program templates, the cell I'm referencing is the Max of the lift and the other cell is the percentage of that lift I want to prescribe. Here is my formula
=IFERROR(IF(ISBLANK($I16),MROUND($E16*$J16,5),MROUND($E16*$I16,5)&"-"&MROUND($J16*$E16,5)),"")
Any help would be great and appreciated! Thank you!