if (25¢ or 10¢)? formula help

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_Bigred

Hello All,

(Excel 2000)


I need to create a cell that does the following:

If B1 is less then $13.00 it would add up to a maximum of 25¢, and if it is
$13.00 or greater it would add 10¢

e.g

IF $12.75 would add 25¢
IF $11.00 would add 25¢
IF $12.98 would add 02¢
IF $13.00 would add 10¢
IF $15.00 would add 10¢

TIA,
_Bigred
 
Try this,

=IF(B1<13,MIN(B1+0.25,13),B1+0.1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
If the amount you are working with is in A1,

=IF(A1<=12.75,A1+0.25,IF(AND(A1>12.75,A1<13)=TRUE,13,A1+0.1))

(all on one line) will work.

Regards,

David Obei
 
Bob,

Your formula works for $13.00 or greater, but anything under $13.00 gets
#Value!

I am going to try DaveO's formula.

Thanks,
_Bigred
 
Hello David O,

Your formula appears to work properly.

Thanks much,
_Bigred



DavidObeid said:
If the amount you are working with is in A1,

=IF(A1<=12.75,A1+0.25,IF(AND(A1>12.75,A1<13)=TRUE,13,A1+0.1))

(all on one line) will work.

Regards,

David Obeid


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Works fine for me.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I will checkit out again and see. DaveO's formula worked good.

I will checkit out later tonight, and post a response. (Maybe I messed up a
character or something)

Thanks,
_Bigred
 
Dave

Sure did miss that part. On second read I notice the 2 cents at 12.98

Thanks, Gord

That won't work for him, it needs to make 12.98 into 13, not 13.23.
Click to expand...
 
Bob's formula works fine. I would probably add this

=IF(B1=0,0,IF(B1<13,MIN(B1+0.25,13),B1+0.1))

just in case there might be a zero there
 
thanks



Peo Sjoblom said:
Bob's formula works fine. I would probably add this

=IF(B1=0,0,IF(B1<13,MIN(B1+0.25,13),B1+0.1))

just in case there might be a zero there

--

Regards,

Peo Sjoblom

up
Click to expand...
 
Back
Top