| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple If formula but can't get my head around it!
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Simple If formula but can't get my head around it!
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Simple If formula but can't get my head around it!
This will also check for TEXT in A2.........
=IF(OR(A2="",ISTEXT(A2)),"",IF(A2=326,"Pass","Fai l")) Vaya con Dios, Chuck, CABGx3 "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 |
|
#4
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 |
| Reply |
| 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 | |||
Linear Mode
