When I see the answer I'll kick myself.

[Stoobydoo]

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,

[Norie]

All you need to do is add the value to return for a false result for the first IF.

=IF(COUNTIF(B4:C4,">=1"),IF(C4<$B$1,1,IF(B4>$B$1,0,($B$1-B4)/(C4-B4))), "")

[Special-K]

...and make sure you follow the rules for naming your threads properly.

https://www.excelforum.com/forum-rul...rum-rules.html

[sandy666]

... and we will see movie how you kick yourself ?

[Stoobydoo]

Norie, thank you! I'm almost positive I tried that but I obviously didn't.

Special K - understood.

Sandy - I've already kicked myself, the bruise is quite big - next time a video.