Formula contd...

Anx · Apr 15th, 2002, 08:39 AM

Hi this works great..

=IF(F7="Refurbished",D7*75%,D7)

other than if F7 doesn't= refurbished i get an error, is there a way to add 'NEW' to the formula please ?

Thanks Anx

kinkyparamour · Apr 15th, 2002, 08:54 AM

=if(f7="refurbished",d7*75%,"new")

Aladin Akyurek · Apr 15th, 2002, 08:57 AM

Quote:

On 2002-04-15 07:39, Anx wrote:
Hi this works great..

=IF(F7="Refurbished",D7*75%,D7)

other than if F7 doesn't= refurbished i get an error, is there a way to add 'NEW' to the formula please ?

Thanks Anx

What do you mean by "error"? This formula will simply return the value in D7, whatever it is, when F7 does not contain "Refurbished" as value.

Anx · Apr 15th, 2002, 11:09 AM

I mean if F7 contains NEW instead of Refurbished i get a NEW istead of a figure.

Is there a way to include NEW in this formula please?

e.g.

Refurb=70% (as it is already)

but

New =100%

I've tried to incorperate it but can't seem to make it work.

what i've actually ended up with is more like this..

=IF(H14="Refurbish",J14/100*'USER SHEET'!C19,H14)(H14="NEW",J14*100%)

This gives me a #REF error though.

I've put the J14*100% in the formula just to try to get the value from J14 into K14 if H14=NEW

I hope this makes sense

Thanks

Anx

[ This Message was edited by: Anx on 2002-04-15 10:11 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 08:39 AM	#1
Anx New Member Join Date: Mar 2002 Posts: 22	Hi this works great.. =IF(F7="Refurbished",D7*75%,D7) other than if F7 doesn't= refurbished i get an error, is there a way to add 'NEW' to the formula please ? Thanks Anx

Apr 15th, 2002, 08:54 AM	#2
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	=if(f7="refurbished",d7*75%,"new")

Apr 15th, 2002, 11:09 AM	#4
Anx New Member Join Date: Mar 2002 Posts: 22	I mean if F7 contains NEW instead of Refurbished i get a NEW istead of a figure. Is there a way to include NEW in this formula please? e.g. Refurb=70% (as it is already) but New =100% I've tried to incorperate it but can't seem to make it work. what i've actually ended up with is more like this.. =IF(H14="Refurbish",J14/100'USER SHEET'!C19,H14)(H14="NEW",J14100%) This gives me a #REF error though. I've put the J14*100% in the formula just to try to get the value from J14 into K14 if H14=NEW I hope this makes sense Thanks Anx [ This Message was edited by: Anx on 2002-04-15 10:11 ]