+ Reply to Thread
Results 1 to 4 of 4

Problems showing a minus figure with an IF formula...

  1. #1
    Forum Contributor
    Join Date
    12-08-2015
    Location
    London, England
    MS-Off Ver
    2021
    Posts
    142

    Problems showing a minus figure with an IF formula...

    Hi all,

    I'm trying to make excel show minus values if a certain CELL is changed to another value.

    So say in column B they change it from 'option A' to 'option B', when they then enter the numeric values in column D i'd like it to show a minus value instead - is this possible?

    I've tried =IF(B1='option B',D1=*-1.... etc, but that's gibberish to excel.

    suggestions/pointers greatly appreciated

    Cheers,

    Weasel.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Problems showing a minus figure with an IF formula...

    maybe: =IF(B1="option B",D1*-1.... etc

  3. #3
    Forum Contributor
    Join Date
    12-08-2015
    Location
    London, England
    MS-Off Ver
    2021
    Posts
    142

    Re: Problems showing a minus figure with an IF formula...

    That works, but it doesn't replace the value of the cell that they're entering. If i enter that formula into D1 i get a circular reference.

    Is there a way of employing that formula in D1 so that it works or would i have to put it into another cell and paste the value into D1 each time?

    Thanks again

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Problems showing a minus figure with an IF formula...

    Formula cannot change value of the other cell(s)
    you need vba probably (try here: Excel Programming / VBA / Macros )

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Array formula turning my final figure into a minus value
    By chrisandsally in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2015, 12:36 PM
  2. [SOLVED] calculating formula with a minus figure
    By shrubfact in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2014, 01:29 PM
  3. Preventing a minus figure being displayed when linked to other formula
    By Illustris13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2013, 06:39 PM
  4. [SOLVED] Replacing a 'minus figure' with a zero
    By Illustris13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2013, 06:08 PM
  5. [SOLVED] I neeed help on changing a minus figure so it does not show a minus
    By Kirstg in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-24-2012, 11:44 AM
  6. Cross Reference to a Figure actually showing figure, not just caption
    By mgaworecki in forum Word Formatting & General
    Replies: 2
    Last Post: 02-23-2012, 10:53 AM
  7. Replies: 4
    Last Post: 09-24-2007, 06:12 AM

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