Need formula
Results 1 to 9 of 9

Thread: Need formula

  1. #1
    New Member
    Join Date
    Jul 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need formula

    Hi everyone!

    If A1 has the text "Cement" then it should calculate and produce result in A5 like this (A2/105*100). A2 will have some numerical value. If A1 does not have Cement then A5 should show 0.

    Please advise and provide a formula for the above request.

  2. #2
    New Member
    Join Date
    Nov 2009
    Location
    Chennai, India
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need formula

    Below formula will go in A5

    =IF(A1<>"Cement",0,(A2/105*100))
    Last edited by Kingarvind1; Jul 31st, 2018 at 05:06 AM.

  3. #3
    New Member
    Join Date
    Jul 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need formula

    It gives 0 as answer, even if A1 has cement.

  4. #4
    Board Regular
    Join Date
    Feb 2010
    Location
    London, UK
    Posts
    9,282
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Need formula

    Try:
    Code:
    =(A1="Cement")*(A2/105*100)


  5. #5
    New Member
    Join Date
    Jul 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need formula

    Used the formula =(A1="Cement")*(A2/105*100) in A5. It is still the same, answer is 0.

  6. #6
    Board Regular
    Join Date
    Feb 2010
    Location
    London, UK
    Posts
    9,282
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Need formula

    When I put Cement into A1 and 3 into A2, with the suggested formula, I got 2.857143 in A5
    When I deleted A1, then I get 0 in A5
    I'm using Excel 2016

    Try:
    Code:
    =--(A1="Cement")*(A2/105*100)


  7. #7
    New Member
    Join Date
    Jun 2018
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need formula

    =IF(A1="cement", (A2/105*100),"0") will work as long as you have some data in A2 otherwise it will show 0.

  8. #8
    New Member
    Join Date
    Jul 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need formula

    This works fine. Thanks, Ryan.

  9. #9
    Board Regular
    Join Date
    Feb 2010
    Location
    London, UK
    Posts
    9,282
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Need formula

    Arunachalam, Ryan confirmed my suggested formula works, as long as A2 is not blank and I suggested adding -- to it if what originally suggested didn't work.

    What do you have working now and is it because A2 is not blank?


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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