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

Joined
Jan 11, 2018
Messages
1
Reaction score
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)
 
Joined
Feb 21, 2018
Messages
216
Reaction score
86
Please try this:

=IF($E119="Available",text(SUMIF($C$2:$C$200,$C119,$G$2:$G$200),"###.##"),"")
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top