Range of cells depending on a condition.
Solved/Closed
Related:
- Range of cells depending on a condition.
- Based on the values in cells b77 b88 - Excel Forum
- How to increase wifi range from router settings - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
- Apple airtags range - Guide
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