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 * 10

Example
If the number is 3 forumla: 24.40 + (1*10) = 34.40

If the number is 4 formula: 24.40 + (2*10) =44.40

etc.


See More: IF statement to do Calculation

Report •


✔ Best Answer
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

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
✔ Best Answer
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 •


Ask Question