Limit Value entered in cell.

  • Thread starter Thread starter Yo
  • Start date Start date
Y

Yo

In this "IF" statement is it possible to limit the value for C4 to no
greater than 12?


=IF(C4+D4-1=0,"",C4+D4-1)

Thanks,
Yo
 
Hi Yo!

I'm not sure you've explained yourself well but is this what you want?

=IF(MIN(C4,12)+D4-1=0,"",MIN(C4,12)+D4-1)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
You can limit the value in C4 by using Data/Validation (see XL Help)

You can have any value in C4, but use a maximum of 12 in the formula
like this:

=IF(MIN(C4,12) + D4 - 1 = 0, "", MIN(C4, 12) + D4 - 1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
change cell color depending on two cell values 1
If sum 5
Nested IF formula question 3
need help on MAX 12
#VALUE error add'g formulas 1
Compensating for Excel rounding errors 8
Nested if 4

Back
Top