How to get output of the formula instead of True or false

Excel Discussion in 'Microsoft Office' started by PradeepKG, Jan 11, 2018.

  1. PradeepKG

    PradeepKG

    Joined:
    Jan 11, 2018
    Likes Received:
    0
    In excel cell - I want to get the Output value to be displayed instead of Ture or False (0/1) values. How to get this?
    This is my formula
    =IF($E119="Available",SUMIF($C$2:$C$200,$C119,$G$2:$G$200))
    Expected value is 0.6 where as its returning 0 (true)
     
    PradeepKG, Jan 11, 2018
    #1
    1. Advertisements

  2. PradeepKG

    AmjiBhai

    Joined:
    Feb 21, 2018
    Likes Received:
    37
    Please try this:

    =IF($E119="Available",text(SUMIF($C$2:$C$200,$C119,$G$2:$G$200),"###.##"),"")
     
    AmjiBhai, Feb 23, 2018
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.