Formatting Numbers after decimals

Hi folks,

I’m having a bit of trouble formatting a cell. File attached. If you were to look at Cell CF100, it doesn’t look like anything or the way I want it to show like that in the cell above it. I tried the formula in another cell, in Cell CF108 and it gives me way to many numbers after the decimal where all I want is to display the number as a whole, i.e 56 since we round up. Now, I tried formatting the cell to do that however it’s not working. So I don’t know why in Cell CF99 it is ok however the 2 cells below it are not formatted or displayed in the same way even though all I did was copy formula’s.

Cell CF100 is referenced to Cells BS122:BX128 but I cleared it a made new in Cells BM130:BR135. There, you can see that certain cells shows the decimals however, when I format it to only show a whole number i.e what was 68.625 is now 69, Cell CF100 still shows many numbers after the decimal, again, even though I formatted the cell as well.

Any idea what I’m doing wrong?? I thought of using the TRUNC function but wasn’t sure if that would fix the problem.

A similar problem appeared on this forum a few days ago and the only "solution" was use TEXT to format the number ..

=IFERROR(IF(OR(BO135<=CF103,BO135<=CFM!E13,CFM!E15=Corrections!I12,CFM!E18="TOGA"),"TOGA","FLEX "&TEXT(BO135,"0.00") &" °C"),)

@MrShorty

The formula in CF99 is formatted as NUMBER and works as if was only number. As I said in my previous post, this problem was recorded a few days ago with identical results i.e, worked in one case but not in what are identical circumstances.

Originally Posted by MrShorty

"FLEX "&TEXT(BO135,"0")&" °C"

Does that help?

Thanks for the help. I tried that and didn't work however, below seemed to work. Just needed to add the ),) in the end as JohnTopley suggested.

TEXT(BO135,"0.00") &" °C"),)

Originally Posted by JohnTopley

A similar problem appeared on this forum a few days ago and the only "solution" was use TEXT to format the number ..

=IFERROR(IF(OR(BO135<=CF103,BO135<=CFM!E13,CFM!E15=Corrections!I12,CFM!E18="TOGA"),"TOGA","FLEX "&TEXT(BO135,"0.00") &" °C"),)

Thank you John. It works now. I did try to search in the forum for a solution, perhaps I didn't use the right keywords. It just seems strange to me that in Cell CF99, I didn't have to input the TEXT function in the formula and still got the result as displayed yet in Cells CF100 & CF101, it didn't display the result as in Cell CF99. Even if you were to look in Cells CF13:CF15, the formula there doesn't have the TEXT function and results displayed as it should. Perhaps like you said if I understood correctly, worked in one case but not in what are identical.