IF Function to automatically round multiple columns of cells down to 100

**al2986** · 08-13-2021, 03:59 PM

I need an IF function that will automatically round cells down 100.
I know I can use the Floor function, but I will have to manually go in and enter it for every cell. What would the IF function look like?

**TMS** · 08-13-2021, 04:44 PM

More clues, examples and expected results … in a sample workbook.

IF Function to automatically round multiple columns of cells down to 100

LinkBack

Thread Tools

Rate This Thread

Display

IF Function to automatically round multiple columns of cells down to 100

Re: IF Function to automatically round multiple columns of cells down to 100

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to PRESENT round-down, but not perform round-down function?

Apply Round Formula to Multiple Cells

[SOLVED] Insert round function to several cells in a column

Round off multiple cells in excel

[SOLVED] Conditional Round up or Round up Function

VB Function Round vs Excel function Round not behaving the same Od

[SOLVED] How can I apply the ROUND function to a range of cells in a workbo

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions