If then excel entry

Solved/Closed
Jen - 15 Feb 2011 à 14:33
 Jen - 18 Feb 2011 à 08:29
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
17 Feb 2011 à 08:41
try this

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