Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF Function
I've numbers "002170" in A2 and "044925" in B2. I want to put a number in C2
such that if the number is =A2 but <=B2, then a statment "It is fine" else "" appears in D2. What the formula would be? Please correct my formula below: =IF(D2=A2 AND D2<=B2,"It is fine","") Another question is how can I show the number "002170" in A2 beside adding a ' in front of the number? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |