Solved IF statement to do Calculation

July 28, 2011 at 12:50:05
Specs: Windows XP
 I need a calculation as follows: If the number is < 2 it should be 24.40, if it is > than 2 it should be 24.40 + difference * 10ExampleIf the number is 3 forumla: 24.40 + (1*10) = 34.40If the number is 4 formula: 24.40 + (2*10) =44.40etc.

See More: IF statement to do Calculation

July 28, 2011 at 13:00:45
 This will evaluate to 24.40 for A1 <= 2 and do your calculation for A1>2:=IF(A1<2, 24.4, 24.4+(A1-2)*10)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

#1
July 28, 2011 at 12:55:43
 What if the number equals 2?

Report •

#2
July 28, 2011 at 12:57:38
 Sorry you're right, it should be if it is less than or equal to 2

Report •

#3
July 28, 2011 at 12:58:19
 ugh sorry, <=2 should = 24.40

Report •

Related Solutions

#4
July 28, 2011 at 13:00:45
 This will evaluate to 24.40 for A1 <= 2 and do your calculation for A1>2:=IF(A1<2, 24.4, 24.4+(A1-2)*10)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#5
July 28, 2011 at 13:03:07
 two ways of achieving this that I am aware of=max(24.40,24.40+(A1-2)*10)or =if(A1<2,24.40,24.40+(A1-2)*10)As long as something completely difference does not occur when the value is equal to 2 the above will work. if something different happens, then you will need to use another if statement to hand that condition.=if(A1=2,(place vbalue of 2 formula),(place one of the formulas from above))Wow a lot has happened since I started typing this.

Report •

#6
July 28, 2011 at 14:32:07
 AWESOME!!! thanks so much this worked!

Report •