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

P

PradeepKG

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)
 
Please try this:

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