Consulting

Results 1 to 2 of 2

Thread: formula

  1. 02-10-2019, 06:59 AM #1
    rjw29bs4
    rjw29bs4 is offline
    VBAX Regular
    Joined
    Aug 2016
    Posts
    12
    Location

    formula

    hi help
    i have this formular in 
    e22 =IF(C22>0,C22/1/6,".")
    i also want to put another in e22 doing if d22 show a 9 then place a 0 in e22 any other number when act on 
    =IF(C22>0,C22/1/6,".")
    please help
    regards
    roger
    Reply With Quote Reply With Quote
  2. 02-10-2019, 09:52 AM #2
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    =IF(D22=9,0,IF(C22>0,C22/6,"."))
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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