Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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.








See more

1 reply

Answer 1 / 1
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)))
Report

Thank you very Much!!! Worked like a charm!!
Ask a question