Guys,
I don't know why I can't work this out, tired maybe.
I've the below formula which works except for the below reason:
=IF(COUNTIF(B4:C4,">=1"),IF(C4<$B$1,1,IF(B4>$B$1,0,($B$1-B4)/(C4-B4))))
If B4:C4 count is 1 or greater it correctly performs the above function.
Where it falls down is if B4 and C4 are blank as then the formula returns false.
I think I need an iferror added in so the false returns blank.
Can you please help,
Pete if this is you again I apologise!
Regards,
Bookmarks