If then excel entry

Solved/Closed
Jen - Feb 15, 2011 at 02:33 PM
 Jen - Feb 18, 2011 at 08:29 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 17, 2011 at 08:41 AM
try this

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