![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
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 |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Feb 2002
Location: Florida
Posts: 82
|
=if(f7="refurbished",d7*75%,"new") |
|
|
|
|
|
#3 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,314
|
Quote:
|
|
|
|
|
|
|
#4 |
|
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",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 ] |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|