View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Natalie[_4_] Natalie[_4_] is offline
external usenet poster
 
Posts: 2
Default 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!! :)