Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create a formula
I needed to know how or what easy way to create formulas. I wanted to to
create a cell that shows if I enter a number less than three it will show as negitive and of coruse if it three or higher it stays in the positve? -- Looking for help. |
#2
|
|||
|
|||
This formula will display the results you want of a cell *other* then the
cell that contains this formula: =A1*(-(A1<3)+(A1=3)) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "B LO" wrote in message ... I needed to know how or what easy way to create formulas. I wanted to to create a cell that shows if I enter a number less than three it will show as negitive and of coruse if it three or higher it stays in the positve? -- Looking for help. |
#3
|
|||
|
|||
Here is a simple function. Need to add this in a module in VBA.
Function test(ByVal intVal As Integer) As Integer If intVal < 0 Then test = intVal ElseIf intVal = 0 And intVal < 3 Then test = intVal * -1 Else test = intVal End If End Function "B LO" wrote: I needed to know how or what easy way to create formulas. I wanted to to create a cell that shows if I enter a number less than three it will show as negitive and of coruse if it three or higher it stays in the positve? -- Looking for help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Formula for calculating Little League Age... | Excel Worksheet Functions | |||
how do I create a if-then formula? | Excel Worksheet Functions | |||
How to create specific formula | Excel Worksheet Functions | |||
How do I create a formula that would allow me to subtract from a d | New Users to Excel | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions |