Range of cells depending on a condition.
Solved/Closed
Related:
- Range of cells depending on a condition.
- Apple airtag range - Guide
- An example of a cell is a blank cell ✓ - Programming Forum
- If a cell has text then return value ✓ - Excel Forum
- How would you change all cells containing the word pass to green - Excel Forum
- 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
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 29, 2015 at 08:09 AM
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
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
Sep 29, 2015 at 09:03 AM