+ Reply to Thread
Results 1 to 6 of 6

if cell equals y multiply by

  1. 01-03-2019, 06:20 PM #1
    dullster
    dullster is offline
    Registered User
    Join Date
    01-27-2015
    Location
    Wisconsin, USA
    MS-Off Ver
    2007
    Posts
    3

    if cell equals y multiply by

    if cell c25 >=y then multiply cell g4 by 20%

    I typed in =IF(C25,"=>1500",G3*0.2) but my sum is =>1500

    Thanks
    Reply With QuoteRegister To Reply
  2. 01-03-2019, 06:28 PM #2
    Keebellah
    Keebellah is offline
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,906

    Re: if cell equals y multiply by

    If you want g4 but multiply g3 ...

    You don't use quotes in formulas
    Since I don't know which 20% of what

    something like this
    Please Login or Register  to view this content.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you
    Reply With QuoteRegister To Reply
  3. 01-03-2019, 06:31 PM #3
    dullster
    dullster is offline
    Registered User
    Join Date
    01-27-2015
    Location
    Wisconsin, USA
    MS-Off Ver
    2007
    Posts
    3

    Re: if cell equals y multiply by

    I did that and i'm getting a "Problem with this formula" message.

    Got it, had a comma after C25.
    Thanks
    Last edited by dullster; 01-03-2019 at 06:34 PM.
    Reply With QuoteRegister To Reply
  4. 01-04-2019, 02:50 AM #4
    Keebellah
    Keebellah is offline
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,906

    Re: if cell equals y multiply by

    And did it do the 'trick'?
    Reply With QuoteRegister To Reply
  5. 01-04-2019, 09:36 AM #5
    dullster
    dullster is offline
    Registered User
    Join Date
    01-27-2015
    Location
    Wisconsin, USA
    MS-Off Ver
    2007
    Posts
    3

    Re: if cell equals y multiply by

    It did. Thank you
    Reply With QuoteRegister To Reply
  6. 01-04-2019, 10:09 AM #6
    Keebellah
    Keebellah is offline
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,906

    Re: if cell equals y multiply by

    Good to hear that.
    Happy coding
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. If Cell Equals Text Then Cell Equals This Cell *
    By cellequals in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-19-2017, 10:23 PM
  2. [SOLVED] if cell equals y multiply
    By swfarm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2017, 03:58 PM
  3. If this number equals _____, then multiply this other number by _______
    By mikeking_ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-07-2016, 10:27 AM
  4. Counting if 1 cell equals X and another equals Y
    By SianPE in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-08-2014, 06:39 AM
  5. [SOLVED] Multiply, Divide and Then Multiply in a cell
    By Brownie2576 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-22-2012, 08:57 PM
  6. If Year equals 1999 then multiply cell by x
    By logan_48080 in forum Excel General
    Replies: 3
    Last Post: 10-05-2005, 02:55 PM
  7. custom filter does not work when selecting 'equals' X AND 'equals'
    By plindman in forum Excel General
    Replies: 1
    Last Post: 06-01-2005, 07:05 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