Excel formula needed for worksheet

Question

What is the Excel formula for IF cell D2 is less than 60% of cell d1, then copy cells d1 thru d10?

I have tried the =IF formula, but can't get cwlls d1-d10 to show up.

Hi and welcome to SU. What version of Excel are you using?
– FlexYourData
Jun 17, 2020 at 20:43 — FlexYourData, Jun 17, 2020 at 20:43

FlexYourData · Accepted Answer · 2020-06-17 20:48:29Z

0

If you are using Excel 365 and you have access to dynamic arrays, you can do this:

This is the formula in cell C1:

=IF(A2<A1*0.6,A1:A10,"")

If the value goes above 19 in this example:

answered Jun 17, 2020 at 20:48

FlexYourData

6,8402 gold badges7 silver badges23 bronze badges

Awesome! That was it! Thank you
– Scott
Jun 17, 2020 at 22:24
This works even in another versions of Excel Or U may use any of these, =IFERROR(IF(A2<A1*0.6,A1,""),"") or you may flip it =IFERROR(IF(A2<A1*0.6,"",A1),"")
– Rajesh Sinha
Jun 18, 2020 at 7:51

Add a comment |

1 Answer 1