# Thread: 'greater than' formula (Excel 97)

1. ## 'greater than' formula (Excel 97)

I'm just learning formulas. This will probably be very simple for the majority but I am totally frustrated at this point in time. Been playing with this for over 30 min. I have a list of numbers that I need to calculate a cost on. If the number is 150 or less the cost will be \$30. If the number is over 150 the cost will be \$30.00 + \$0.17 and the difference between number listed and 150. This is what I have but it is returning true or false. =IF(A1<150=30, IFA1>150-A1*0.07) Please help. Thanks in advance.

Example follows:

48 This should total \$30.00 because it is less than 150
193 This should total \$37.31 because \$30 for the 150 plus \$7.31 for the additional 43.
288
235
229
239
200
167
245
220
263
183
276
171
291
229
54

2. ## Re: 'greater than' formula (Excel 97)

Try this:

=IF(A1<150, 30, (A1-150)+30.17)

is this what you need?

3. ## Re: 'greater than' formula (Excel 97)

I finally got the formula after another 30 minutes.
=IF(K3<150,"30",IF(K3>150,((K3-150)*0.17)+30))
Persistence pays off. Just knowing the Lounge is here helps with the stress levels. I know that help is not far away.

4. ## Re: 'greater than' formula (Excel 97)

FWIW, using your new formula, what happens if a1 = 150? try this.

=if(a1>150,30+((a1-150)*0.17),30)

5. ## Re: 'greater than' formula (Excel 97)

Or:

=30+(A2>150)*(A2-150)*0.17

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•