Dec 30 2020 06:31 AM
SolutionDec 30 2020 08:45 AM
Depends on where the result shall be. If in some other cell, when as suggested. If B1 shall be changed depends on B5, when VBA.
Dec 30 2020 06:31 AM
Solution=IF(B5<=22,B1/2,B1)
or
=B1/IF(B5<=22,2,1)
or
=B1/((B5<=22)+1)