Need Formatting Help

tphillips

Board Regular
Joined
Jan 28, 2003
Messages
76
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
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
tphillips said:
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"
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,076
Members
412,566
Latest member
TexasTony
Top