You haven't told us what the expected result is, but I'm guessing it should be 0.8 rather than -0.8.
If that's the case then try this:
=B32-COUNTIF(B2:B31,">0")*K1
BSB
You haven't told us what the expected result is, but I'm guessing it should be 0.8 rather than -0.8.
If that's the case then try this:
=B32-COUNTIF(B2:B31,">0")*K1
BSB
Yes. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks