Results 1 to 6 of 6

if formula - need advice

Threaded View

koi if formula - need advice 09-25-2012, 09:15 AM
jeffreybrown Re: if function 09-25-2012, 09:26 AM
Jakobshavn Re: if function 09-25-2012, 09:27 AM
koi Re: if formula - need advice 09-25-2012, 10:03 AM
jeffreybrown Re: if formula - need advice 09-25-2012, 10:05 AM
arlu1201 Re: if formula - need advice 09-25-2012, 11:35 AM
  1. #1
    Registered User
    Join Date
    03-10-2005
    MS-Off Ver
    Excel 2013
    Posts
    95

    if formula - need advice

    hi all,

    i need help in if function as example below

    A1 = Apple
    A2 = Apple

    B1 = if(and(A1="Apple",A2="Apple"),"fruit",...xxx..)

    in xxx i want to return whatever value in either A1 or A2 if it is not apple

    example A1 = Apple and A2 = banana...so it will return as Banana in value if false.

    thanks
    Last edited by koi; 09-25-2012 at 10:00 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1