Hi,

type this in cell B1:

=IF(A1<5,A1*(A1-5),A1*(A1+5))

Regs,

Dominic

Natalie wrote:
How do I type it in Excel without using macros to achieve the following
function?

If A1<5, then B1 = A1*(A1-5)
If A1=5, then B1 = A1*(A1+5)

Any help is much appreciated!! :)