If / Then statement with multiple conditions for range of cells

**micina** · 09-06-2017, 03:50 PM

I want to create a macro that outputs the text "Priority" in column F if the adjacent cell (column E) is greater than 7% and the cell in column D is greater than 10. I want this code to apply to the entire sheet (there are 900 rows). What would the code be for that function?

**PCI** · 09-06-2017, 04:42 PM

What about
F12 =IF(AND((D12>10);(E12>0.07));"Priority";"")
Copy and drop down as needed

**micina** · 09-06-2017, 05:54 PM

Thanks! Yeah, I ended up using a formula instead. Some things are easier with formulas.

If / Then statement with multiple conditions for range of cells

LinkBack

Thread Tools

Rate This Thread

Display

If / Then statement with multiple conditions for range of cells

Re: If / Then statement with multiple conditions for range of cells

Re: If / Then statement with multiple conditions for range of cells

Thread Information

Users Browsing this Thread

Similar Threads

IF Statement with Multiple Conditions and Multiple True/False Results

True/False for Multiple conditions and formats in a range of cells

nested IF statement or AND? trying to write an IF statement with multiple conditions

[SOLVED] PROBLEM: IF statement with conditions (multiple cells)

Multiple conditions in IF statement

Multiple conditions in one IF statement

Case Statement using a Range of Conditions

Bookmarks

Bookmarks

Posting Permissions