| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problems with if function
I would like c1 to display b1/a1 if a1 and b1 not empty but would like c1 to
remain empty if nothing in a1 and b1 the following works but only if there is a value in a1 and b1. =IF(AND(A1="", B1=""),"", B1/A1) if a1 and b1 empty c1 shows hashkey value! what am I doing wrong |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems updating shared documents which used "Lookup" function | Excel Discussion (Misc queries) | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Linest function: data selection problems | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| opening up an english excel sheet onto a french verions - problems with edate function | Excel Discussion (Misc queries) | |||
Threaded Mode
