If then excel entry [Solved/Closed]

Report
-
 Jen -
Hello,

In excel, I have a row where hours worked is entered.
Directly underneath that row is another row where allotted break time needs to be automatically populated. That time is based on whatever value is in the cell directly above it (IE cell a2 references a1; b2 references b1, c2 references c1, etc.)


If a1 = 8 then a2 should populate 1
If a1 < 8 then a2 should populate .25
If a1 > 8 then a2 should populate 1.25

And so on for all columns.

Is this possible and how can I accomplish this?

Thank you.








1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
try this

=IF(A1="","",IF(A1<8,0.25,IF(A1=8,1,1.25)))
Thank you very Much!!! Worked like a charm!!