Expanding on existing VBA code

[gss]

I have the following code:

If Application.RoundDown(Left_Cell, 2) = Application.RoundDown(Cp_1, 2) Then SectionBottom = Cp_1 - (O_1 / 12): Exit Function

What I would like for it to do is to continue to execute the above function if O_1 > 0 or O_1 < 0, but if O_1 = 0, then to ignore the code. So in effect, if O_1 = 0, exit the function without assigning a value to SectionBottom.

Any advice?

Thanks.

[Cheeky Charlie]

if not O_1 = 0
(your line without the : exit function)
end if
exit function

Code's easier to read (hence debug) if you break out your ifs into blocks, so I'd actually recommend:

if not O_1 = 0
If Application.RoundDown(Left_Cell, 2) = Application.RoundDown(Cp_1, 2) Then
SectionBottom = Cp_1 - (O_1 / 12)
end if
end if
exit function

I'd also indent it, but I can't do that without easily using the VBE and without any context I can't really test what I'm telling you

HTH