+ Reply to Thread
Results 1 to 2 of 2

Copy Formula based on a cell

Hybrid View

  1. #1
    Registered User
    Join Date
    03-09-2021
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    3

    Copy Formula based on a cell

    Hello,

    So i have to get a formula based on a cell to automate some paychecks.

    In column M i have the data i want to check

    i have 5 VALUES, CTT40, CTT30, CTT20, RV, AF

    Based on those values i want to get:

    if column M CTT40: =+IF(Q5>=70;0,7*AG5;
    if column M CTT30: =+IF(Q5>=21;(2,65*U5)+500;
    if column M CTT20: =+IF(Q5>=21;(2,65*U5)+500;
    if column M RV: =0
    if column M AF: =U5*1,35

    Its possible to make this?

    Thanks in advance!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Copy Formula based on a cell

    Hi there.


    It looks like your criteria are incomplete.... but...

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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. Auto copy formula based on another cell value
    By naga1977 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2021, 10:31 PM
  2. Formula- Copy number of rows based on cell value
    By Ales Michek in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-11-2021, 02:41 PM
  3. [SOLVED] How to copy row to another sheet based on cell value - Macro or Formula
    By arwinn in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-31-2021, 12:59 AM
  4. Copy images in cell based on formula
    By darxide23 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2015, 04:04 PM
  5. [SOLVED] Copy a formula x times sideways based on value in a cell
    By fokeiro in forum Excel General
    Replies: 5
    Last Post: 03-08-2013, 02:50 PM
  6. Replies: 3
    Last Post: 05-14-2012, 10:29 AM
  7. Like to copy cell based on value derived from Formula
    By Leo2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2010, 11:22 PM

Tags for this Thread

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