Try
=or(iserror((A3+$K$2)/(B3-2)),((A3+$K$2)/(B3-2))<0)
as CF ( the SUM function you used is redundant)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|