function arguments
On Nov 13, 1:18*pm, Oregongal35
wrote:
Sorry this is my formula,
[....]
=IF(roc1*2%<500," 500",roc1*2%)
=if(roc1*2% < 500, 500, round(roc1*2%,0))
Note that I replaced " 500" with just 500. If instead you want the
result to always be text with one leading space, try:
=if(roc1*2% < 500, " 500", text(roc1*2%, " 0"))
Note that the TEXT() function does the rounding for you. Also note
that there is a space before 0 in the last term.
More simply, replace the IF() function with one of the following:
=round(min(roc1*2%,500), 0)
=text(min(roc1*2%,50), " 0")
|