| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple If formula but can't get my head around it!
Thanks Danny, just what I wanted
Cheryl "Danny Lewis" wrote: Hi Cheryl =IF(A2="","",IF(A2=326,"Pass","Fail")) Danny "Cheryl" wrote: I have column A which has a score in it . In column B I have the formula: =IF(A2=326,"Pass","Fail") This works ok but enters Fail even if there is no entry in column A. I want to add to the formula the condition that if the cell is blank then the cell in column B should also be blank. I would be grateful for any help, Thanks, Cheryl |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i know this is simple, but driving me nuts - formula | Excel Worksheet Functions | |||
| Simple Excel Formula Help | New Users to Excel | |||
| When inserting a simple "Sum" formula all I get is the formula. | Charts and Charting in Excel | |||
| Need help with a simple formula | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
Threaded Mode
