J
jcob2
Ok, I found the answer to my own questions, but now it presents a ne
question.
The formula I want works by adding "&" so it reads:
=IF(D9>1,(D9*D8),"<"&(D9*D10))
Now my problem is, the resulting number of D9*10 has like 8 decima
places. The cell is ignoring my command to round off to just 2 decima
places, I guess since it is part of an IF command, and not just
general number in the cell. Or maybe because it has text placed i
front of it? Not sure why, but how do I make this FALSE statemen
return <#.## and not <#.######## ?
question.
The formula I want works by adding "&" so it reads:
=IF(D9>1,(D9*D8),"<"&(D9*D10))
Now my problem is, the resulting number of D9*10 has like 8 decima
places. The cell is ignoring my command to round off to just 2 decima
places, I guess since it is part of an IF command, and not just
general number in the cell. Or maybe because it has text placed i
front of it? Not sure why, but how do I make this FALSE statemen
return <#.## and not <#.######## ?