if (25¢ or 10¢)? formula help

[_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

 

[Bob Phillips]

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)

 

[DavidObeid]

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

 

[Gord Dibben]

Big

=IF(B1<13,(B1+.25),(B1+.1))

Gord Dibben XL2002

 

[Dave R.]

=+IF(13-B1>=0.25,B1+0.25,IF(B1-13>=0,B1+0.1,B1+(13-B1)))

 

[Dave R.]

That won't work for him, it needs to make 12.98 into 13, not 13.23.

Big

=IF(B1<13,(B1+.25),(B1+.1))

Gord Dibben XL2002

 

[_Bigred]

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

 

[_Bigred]

Hello David O,

Your formula appears to work properly.

Thanks much,
_Bigred

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

creating financial statements

 

[Bob Phillips]

Works fine for me.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[_Bigred]

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

 

[Gord Dibben]

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.

 

[Peo Sjoblom]

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

 

[_Bigred]

thanks

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