Using IF statement to make conditional formulas?
 

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!! :)

Using IF statement to make conditional formulas?
 

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!! :)

Using IF statement to make conditional formulas?
 

Natalie,

Select Cell B1 then type =IF(A1<5,A1*(A1-5),A1*(A1+5)).

This should work.






Jon L.

*** Sent via Developersdex http://www.developersdex.com ***

Using IF statement to make conditional formulas?
 

Thank you!! It works :)

J. Leadbeater wrote:
Natalie,

Select Cell B1 then type =IF(A1<5,A1*(A1-5),A1*(A1+5)).

This should work.






Jon L.

*** Sent via Developersdex http://www.developersdex.com ***