excel

[FrostedNipple]

how do i get a number in a box A1 to = 5.75 if box B1 = 0, however if box B1 doesn't = zero then box A1 = 5.35

thanks in advance
FN

 

[noob]

In A1 do this: -

 

[FrostedNipple]

arrr, there is a built in function for this, thanks