CODEWITHSUNDEEP

excelexcel-formula

Reputation: 734

Set subsequent row values based on input

Is it possible to set the value of all cells after a certain date with a defined value? For example, if I input Jul-19 into cell A4, can I fill all cells in a separate row directly below and after this date with the value 28,000, and those before with 0? See below:

Upvotes: 0

Views: 53

Answers (3)

Forward Ed

Reputation: 9874

=(A1>=$A$4)*28000

Something a little shorter and no IF

Edit: and inline with the craner method!

Upvotes: 3

BruceWayne

Reputation: 23283

Just use an If() formula:

=IF(A1<$A$4,0,28000)

Edit: ...in complete opposition to @ScottCraner's answer :P

Upvotes: 3

Scott Craner

Reputation: 152505

Put this in A2 and copy/drag over:

=IF(A1>=$A$4,28000,0)

Upvotes: 3

Related Questions