mbake16
03-23-2009, 07:17 AM
Hello:
In column I of the attached file is an example of the way I'm using the Offset function in a ranking report I'm creating. The formula is to return nothing or "" if the offset cell contains nothing. If the offset cell contains a value the formula performs a division calculation. The formula works great if there is a value in the offset cell, however it returns a #VALUE! error if the offset cell is blank. Is there something I'm doing incorrectly that is causing the #VALUE! to be returned for empty cells? Any suggestions would be great!
Thanks,
Matt
In column I of the attached file is an example of the way I'm using the Offset function in a ranking report I'm creating. The formula is to return nothing or "" if the offset cell contains nothing. If the offset cell contains a value the formula performs a division calculation. The formula works great if there is a value in the offset cell, however it returns a #VALUE! error if the offset cell is blank. Is there something I'm doing incorrectly that is causing the #VALUE! to be returned for empty cells? Any suggestions would be great!
Thanks,
Matt