Results 1 to 3 of 3

If statement problem

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    7

    If statement problem

    Hello all:

    Don't know if this is possible, but....

    I am looking to have a cell either output a number as a percentage or whole number (currency).

    that said if I create a dropdown box that has an if statement tied to it (i.e:=IF(A1="Percentage",...... or A1="Currency"....) how would I make it so that cell A3 is either percentage or currency?

    Moreover, if the user opts for either percentage or currency, am I correct by creating 3 cells to perform task (i.e A1 is data entered, A2 is if statement, A3 is conditional answer cell)?
    Last edited by beamer; 09-18-2012 at 02:36 PM.

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