Results 1 to 3 of 3

Thread: help with rules and commands

  1. #1
    Neophyte Brian57's Avatar
    Join Date
    Mar 2021
    Posts
    1
    Articles
    0
    Excel Version
    office 2019

    help with rules and commands



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there,
    I have been lucky enough to get some answers previously and now have another one
    A rule for my spreadsheet
    Rule can only start when AF8<105 and J3<5but >3
    Ok then we have commands LAY and GREEN
    AK9>0 LAY when and if that happens then "IF AG9 is 10% < AI9 then GREEN" or "H4=0 GREEN"
    if D10>2 GREEN OR IF D10>-2 GREEN
    Thanks Brendan

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,599
    Articles
    0
    Excel Version
    Office 365 Subscription
    No, sorry - makes no sense at all to me.

    Try again with a bit more detail.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,910
    Articles
    0
    Excel Version
    365
    cross posted without links:
    https://www.mrexcel.com/board/thread...mands.1163987/
    where it seems to have been solved…
    Brian 57, *Toota, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •