All,
This should be very simple, but to be frank I am drawing a brain blank. I have two fields and I am trying to get a ratio. For the most part it works but if there is no value in Current Equipment, I get the famous #DIV/0! error that the command staff find a bit on the annoying side.
=IF(OR([Unit Strength]="",[Current Equipment Count]=""),0,ROUNDUP([Unit Strength]/[Current Equipment Count],0))
Any help with modification would be greatly appreciated.
Thanks in advance,
This should be very simple, but to be frank I am drawing a brain blank. I have two fields and I am trying to get a ratio. For the most part it works but if there is no value in Current Equipment, I get the famous #DIV/0! error that the command staff find a bit on the annoying side.
=IF(OR([Unit Strength]="",[Current Equipment Count]=""),0,ROUNDUP([Unit Strength]/[Current Equipment Count],0))
Any help with modification would be greatly appreciated.
Thanks in advance,