| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help with IF function
Hi Everyone.
I am using Excel 2000. I have an IF formula. It first looks to see if J160. If it is, I want it to look at B16 and see if there is any number including zero (0) in the cell. If there is, it is to use B16, if not it is to use cell A16. If I use IF(B16=0), it returns true even if B16 is empty or blank. When B16 is empty or blank, I need the formula to go to A16. Can someone help? Thanks -- Jim |
| 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 | |||
Threaded Mode
