Cell value

Closed

ruda - Feb 8, 2011 at 11:17 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 8, 2011 at 12:19 PM

i hve one cell "c" and i want to set formula like if C>=25 then d=c and if c<25 then d=25

pl. help....

Cell value
If cell contains date then return value - Excel Forum
If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
Conditional formatting if cell contains text - Excel Forum
Count if cell contains number - Excel Forum
Excel send value to another cell - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 8, 2011 at 12:19 PM

in cell D1, you write

=IF(C1="", "", IF(C1 < 25, 25, C1))

Formula is saying
if C1 is blank, then keep d1 blank too
if c1 < 25, then show 25 in d1
if both conditions are not true ( hence c1 is not blank and c1 >=25), then show whats in C1

Similar discussions

If a cell contains any text then add a value

help me to add particular cells

If cell = date return yes or no.

Excel: If Date =, then enter a value

Excel "IF" function w/ date in test cell

Similar discussions

Subscribe To Our Newsletter!