Aug 03 2022 05:27 AM
what's wrong with this formula?: =IF(D157>=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"
Thank you!
Aug 03 2022 09:39 AM
You are a genius! Thank you very much.
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: <1.0,0,
Aug 03 2022 10:04 AM