| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with If Statement
I have inserted an IF statement, =IF(P80,P8-U8), in a spreadsheet cell. In
the spreadsheet cell if P8 = 0 the FALSE statement appears. I would like to eliminate the FALSE statement from the cell contents and only show contents in that cell if P8 0. How can I do this? Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with If Statement
=IF(P80,P8-U8,"") -- Don Guillett Microsoft MVP Excel SalesAid Software "joemsewi" wrote in message ... I have inserted an IF statement, =IF(P80,P8-U8), in a spreadsheet cell. In the spreadsheet cell if P8 = 0 the FALSE statement appears. I would like to eliminate the FALSE statement from the cell contents and only show contents in that cell if P8 0. How can I do this? Thank you |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with If Statement
hi
you don't have enough arguments in the statement. the aguments are.... if(condition, true, false) all you have is..... if(condition,true) excel seems to be filling in the blank. try this. =IF(P8=0,"",P8-U8) regards FSt1 "joemsewi" wrote: I have inserted an IF statement, =IF(P80,P8-U8), in a spreadsheet cell. In the spreadsheet cell if P8 = 0 the FALSE statement appears. I would like to eliminate the FALSE statement from the cell contents and only show contents in that cell if P8 0. How can I do this? Thank you |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with If Statement
For the False condition, use P8
=IF(P80,P8-U8,P8) Jim K "joemsewi" wrote: I have inserted an IF statement, =IF(P80,P8-U8), in a spreadsheet cell. In the spreadsheet cell if P8 = 0 the FALSE statement appears. I would like to eliminate the FALSE statement from the cell contents and only show contents in that cell if P8 0. How can I do this? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Hybrid Mode
