# Simple Excel formula required

Discussion in 'Computer Support' started by sunny, Jan 6, 2004.

1. ### sunnyGuest

I have never really used Excel but im trying to work out a simple formula. I
am trying to make the cell (A2) enter the appropriate listing fees from ebay
depending on what is entered as the opening value price in another cell
(A1). Can anyone give me the formula cos my brains hurting.

cheers

Paul

'an amateur built the the Arc but a professional built the Titanic!'

sunny, Jan 6, 2004

2. ### BobwGuest

sunny wrote:

> I have never really used Excel but im trying to work out a simple formula.
> I am trying to make the cell (A2) enter the appropriate listing fees from
> ebay depending on what is entered as the opening value price in another
> cell (A1). Can anyone give me the formula cos my brains hurting.
>
> cheers
>
> Paul
>
>
> 'an amateur built the the Arc but a professional built the Titanic!'

Bobw, Jan 6, 2004

3. ### sunnyGuest

0.01 - 0.99 fee =0.15
1.00 - 4.99 0.20
5.00 - 14.99 0.35
15.00 - 29.99 0.75
30.00 - 99.99 1.50
100.00 and up 2.00

thanx again

"Bobw" <> wrote in message
news:VXHKb.179919\$ss5.70358@clgrps13...
> sunny wrote:
>
> > I have never really used Excel but im trying to work out a simple

formula.
> > I am trying to make the cell (A2) enter the appropriate listing fees

from
> > ebay depending on what is entered as the opening value price in another
> > cell (A1). Can anyone give me the formula cos my brains hurting.
> >
> > cheers
> >
> > Paul
> >
> >
> > 'an amateur built the the Arc but a professional built the Titanic!'

>

sunny, Jan 7, 2004
4. ### MartikGuest

On Wed, 07 Jan 2004 00:12:49 +0000, sunny wrote:

> 0.01 - 0.99 fee =0.15
> 1.00 - 4.99 0.20
> 5.00 - 14.99 0.35
> 15.00 - 29.99 0.75
> 30.00 - 99.99 1.50
> 100.00 and up 2.00
>
> thanx again
>
>
>
> "Bobw" <> wrote in message
> news:VXHKb.179919\$ss5.70358@clgrps13...
>> sunny wrote:
>>
>> > I have never really used Excel but im trying to work out a simple

> formula.
>> > I am trying to make the cell (A2) enter the appropriate listing fees

> from
>> > ebay depending on what is entered as the opening value price in another
>> > cell (A1). Can anyone give me the formula cos my brains hurting.
>> >
>> > cheers
>> >
>> > Paul
>> >
>> >
>> > 'an amateur built the the Arc but a professional built the Titanic!'

in A2 enter:
=if(a1<1;.15;if(a1<5;.2;if(a1<15;.35;if(a1<30;.75;if(a1<100;1.5;2)))))

Change the ";" to "," I am using Kspread in Linux right now

You can also use tables and a lookup function which would be easier to
maintain.

Aren't there also percentages to calc for ebay fees?

Martik, Jan 7, 2004
5. ### SanoGuest

This is a plain text ng. No attachments.

"bee" <> spluttered in
news:btfss6\$:

> A1 = input value cell
> A2 = ouput value cell (with formula)
>
> The formula for A2 is "
> =IF(A1<A5,A6,IF(A1<B5,B6,IF(A1<C5,C6,IF(A1<D5,D6,IF(A1<E5,E6,2))))) "

Sano, Jan 7, 2004