Need Formatting Help

[tphillips]

I have this formula in a cell =IF(B8<200,"My Text",If(B13<320,"NONE",'Block 9A'!C29&" minutes")). The problem is that the data for "Block 9A!C29" is returned with decimals. I can't format the cell to return no decimals. I've tried custom formatting but it will not work, I guess because of the IF statement. What can I add to the formula to make the value display with no decimals. Thanks

 

[Brian from Maui]

I have this formula in a cell =IF(B8<200,"My Text",If(B13<320,"NONE",'Block 9A'!C29&" minutes")). The problem is that the data for "Block 9A!C29" is returned with decimals. I can't format the cell to return no decimals. I've tried custom formatting but it will not work, I guess because of the IF statement. What can I add to the formula to make the value display with no decimals. Thanks

Try adding,

TEXT('Block 9A'!C29,"00")&" Minutes"