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.








Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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