| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to get a blank cell presented if B26=0
IF B26=0, how do I present a blank cell in another place, or put an amount if
not true. I have used =IF(B26=0,0,Sheet1!E2) , but I get a $0.00 figure which I do not want. Even I if I used a blank cell for the true portion, I get then same $0.00 figure. I get the right amount for false. I am preparing an excel program for a small plowing business. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the order of the series presented in a chart's Leg | Charts and Charting in Excel | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| cell value<presented value | Excel Worksheet Functions | |||
| Click in one field and data presented in another field | Excel Discussion (Misc queries) | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Threaded Mode
