Results 1 to 7 of 7

IF formula with Currency sign

Threaded View

dino4u86 IF formula with Currency sign 03-08-2016, 09:03 AM
udprocks Re: IF formula with Currency... 03-08-2016, 09:12 AM
AlKey Re: IF formula with Currency... 03-08-2016, 09:14 AM
Special-K Re: IF formula with Currency... 03-08-2016, 09:17 AM
dino4u86 Re: IF formula with Currency... 03-08-2016, 09:33 AM
AlKey Re: IF formula with Currency... 03-08-2016, 10:04 AM
dino4u86 Re: IF formula with Currency... 03-08-2016, 09:36 AM
  1. 03-08-2016, 09:03 AM #1
    dino4u86 is offline
    Registered User
    Join Date
    12-14-2014
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    21

    IF formula with Currency sign

    Cell A1 has values in Currency sign - $100
    Cell A2 has values in Currency sign - Euro200

    I want to make an IF formula in cell B1 - If(a1="$",123,321)

    Note: Basically if a cell has dollar sign then separate calculation and if cell having euro sign then separate calculation

    Kindly provide formula
    Last edited by dino4u86; 03-08-2016 at 09:07 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to make the euro currency sign the default
    By joanmolamphy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-19-2015, 11:07 AM
  2. My currency sign was replaced by generic currency sign (excel 2010)
    By yanivg11 in forum Excel General
    Replies: 7
    Last Post: 06-17-2014, 02:15 PM
  3. [SOLVED] Sort By Currency Sign NOT Values
    By vinaynaran in forum Excel General
    Replies: 6
    Last Post: 09-11-2013, 12:18 PM
  4. Concatenate formula not taking decimal places/currency sign
    By woodsonline in forum Excel General
    Replies: 4
    Last Post: 05-27-2009, 03:34 AM
  5. Dollar sign alignment - Accounting vs Currency style
    By MikeC in forum Excel General
    Replies: 3
    Last Post: 03-23-2006, 02:25 PM
  6. [SOLVED] Currency sign.
    By FjV in forum Excel General
    Replies: 2
    Last Post: 10-26-2005, 10:05 AM
  7. Changing Dollar sign to another currency not listed in Excel
    By Rehan in forum Excel General
    Replies: 1
    Last Post: 04-12-2005, 12:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1