Colin2u,

In K42
IF (I30<=K39*0.75,(K39-I30)*0.5,"")

Henry

"Colin2u" wrote in message
...
THIS IS WHAT I WOULD LIKE TO DO:
IF K39-I30 IS =.25% OF K39, THEN DEDUCT .50% OF DIFFERENCE/REMAINDING TO
BE
PLACED IN K42.
SOME HOW IT IS NOT DOING WHAT I THINK IS CORRECT WHEN I REDO IT ON PAPER.