Plz Need help!! Need cell to be "0" and not negative number.

[michael25818]

Hi All!

I've attached an image of what my spreadsheet looks like. Not very experienced in Excel but trying to make this work. I'm using =ROUNDUP(MIN(2,F4-8),0). I need H5 to be "0" and not negative number so H13 is not a negative amount. Any help!! Really really appreciate it!

[Jonmo1]

Try

=MAX(0,ROUNDUP(MIN(2,F4-8),0))

[michael25818]

it worked. Thanks so much! Can you please help me with one more question?
Column G can have a max and minimum of "8". I basically want the only number to appear in that column to be 8 if there are any numbers entered in Columns B,C,E. This is the current formula i have =ROUNDUP(MIN(8,F4),0). now if i use 20 in B4 & 15 in C4, it comes up as 5.

[michael25818]

it worked. Thanks so much! Can you please help me with one more question?
Column G can have a max and minimum of "8". I basically want the only number to appear in that column to be 8 if there are any numbers entered in Columns B,C,E. This is the current formula i have =ROUNDUP(MIN(8,F4),0). now if i use 20 in B4 & 15 in C4, it comes up as 5.

[Jonmo1]

Sorry no, I don't follow what you're trying to do.

[michael25818]

Let me try to clarify. Sorry about that.
G4 can be any number between 0-8 but I only want it to show up as "0" or "8". Not 1, 2, 3, 4, etc.
The formula i'm using is =ROUNDUP(MIN(8,F4),0)
If I enter 20 in B4 and 15 in C4, I get 5. I want that to appear as 8.

Hope that helps. Capture.PNG

[Jonmo1]

Perhaps

=CEILING(ROUNDUP(MIN(8,F4),0),8)

[michael25818]

Thank you so much! I'm playing around in it and you just saved me hours!! Have a great day!

[michael25818]

Hi,

Sorry to bother you again. Wondering if you could possible help me out with another question?
I have one cell which I have writing in but need that locked. I want to be able to come into that cell and just answer Yes or No. I plan on adjusting the size of the cell later.
Capture.PNG