I have a base for timesheets. 
I have a column which is set to decimal for hours total called qty eg. 9.50 or 10.00. 

Then I have a formula that will accept the total hours or put something different depending on leave status abbreviation but it won’t write down the answer as a decimal or let me format it. 

So my formula is -

if({status}=“on”,qty,if(and({status}=“lwop”),“0.00”,if(and({status}=“rdo”),”8.00”)))

And for any of those combinations it comes out like eg 9 or 9.5 for “qty”, 0 for lwop and 8 for rdo 

Can you help me format into same format as my other column and formula examples.