Formula contd...
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Formula contd...

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



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

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,772
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default

    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.

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com