Excel

Question

what's wrong with this formula?: =IF(D157&gt;=5,"5","D157") I want column E to contain number in Column D if less than or = to 5, if greater than 5 then "5"&nbsp;Thank you!

hansvogelaar · Answer

TRM353&nbsp;
"D157" is a literal text string, not a cell reference.
Use
&nbsp;
=IF(D157&gt;=5, 5, D157)
&nbsp;
or shorter
&nbsp;
=MIN(D157, 5)

trm353 · Answer

HansVogelaar&nbsp;&nbsp;You are a genius! Thank you very much.&nbsp;Could I add additional parameters? For example if I wanted to ignore any figures in column D that were less than 1.0 could I add: &lt;1.0,0,

hansvogelaar · Answer

TRM353&nbsp;
That could be
&nbsp;
=MAX(MIN(D157, 5),1)

trm353 · Answer

I probably didn't explain that very well.Column D is random numbers. I would like column E to: be 0 for numbers less than 1.0, be the number in column D if between 1.0 and 5.0 and be 5.0 for numbers greater than 5.0

hansvogelaar · Answer

TRM353
=IF(D157&lt;1,0,MIN(D157,5))

Forum Discussion

Excel

6 Replies

Resources