Range of cells depending on a condition.

Solved/Closed

Milvy - Sep 29, 2015 at 06:05 AM
Milvy - Sep 29, 2015 at 09:03 AM

Hello,

I am trying to change part of a cell reference for a range of cells depending on a condition.
For example, the formulas in column A & E: A1 =sheet2!B1*B1+2, and A2=sheet2!B2*B2+2 E1=sheet2!B1*B1-2 etc.

If C1=yes then i want to change all cell references in column A & E to any column B to change to D: A1=sheet2!D1*D1+2, A2=sheet2!D2*D2+2 E1=sheet2!D1*D1-2 etc.

Can someone help me with this?

Range of cells depending on a condition.
Apple airtag range - Guide
Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
Apply conditional formatting to the selected cells ✓ - Excel Forum
How to apply a macro to a range of cells ✓ - Excel Forum
An example of a cell is a blank cell ✓ - Programming Forum

1 response

Answer 1 / 1

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 29, 2015 at 08:09 AM

Milvy, Good morning.

Try to use:

A1 =IF(C1="YES";Sheet2!D1*D1+2;Sheet2!B1*B1+2)

A2 =IF(C1="YES";Sheet2!D2*D2+2;Sheet2!B2*B2+2)

E1 =IF(C1="YES";Sheet2!D1*D1-2;Sheet2!B1*B1-2)

Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Milvy
Sep 29, 2015 at 09:03 AM

Awesome! thank you very much!

Similar discussions

Excel if range of cell contain a text put a cell value in

help me to add particular cells

Condition formatting on changing cell color based on another cel

Excel Macro - Set and autofill a range?

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!