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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 8, 2011 at 12:19 PM
Related:
- Cell value
- Cell phone codes - Guide
- Excel cell color formula - Guide
- Conditional formatting if cell contains text ✓ - Excel Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 8, 2011 at 12:19 PM
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
=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
