-
Re: Mround and Round functions
Formula Description Result MROUND(27, 5) Rounds 27 to the nearest multiple of 5. 25 MROUND(134, 10) Rounds 134 to the nearest multiple of 10. 130 MROUND(8.6, 0.5) Rounds 8.6 to the nearest multiple o…1 · -
Re: Another COUNTIFS question with multiple criteria **Answered**
=COUNTIFS( {HR Info Systems COE Tracker Range 4}, [Metrics 2]@row, {HR Info Systems COE Tracker Status}, OR(@cell <>"Complete",@cell <>"Cancelled"))1 · -
Re: Date Column
Missing comma,1 · -
Re: Help with LEFT formula
=IF(LEFT([Evaluation Date]@row) = "F", "Fraud", IF(LEFT([Evaluation Date]@row) = "C", "FIU", ""))1 · -
Re: COMBINING COUNTIFS with AND, for multiple Columns! Help!
=COUNTIFS( {DCYF OneWA Pulse-checks Range 11}, Answers@row, {DCYF OneWA Pulse-checks Range 11},"disagree", {DCYF OneWA Pulse-checks Range 11},"strongly disagree") You can go thru …1 ·