Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF Function
Anyone,
Is there a function where if the results of an equation are not above a value that you need, to make that cell blank? For instance, =A1*A2, if the answer to that equation is less than .01, just leave the cell blank. Thank You |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF Function
hi
yes. =if(A1*A2<.01,"",A1*A2) regards FSt1 "Scott" wrote: Anyone, Is there a function where if the results of an equation are not above a value that you need, to make that cell blank? For instance, =A1*A2, if the answer to that equation is less than .01, just leave the cell blank. Thank You |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF Function
Depends on what you mean by "blank". Visually, you can use "" as already
suggested. For data to be plotted use #N/A. Either way, formulas may need to be adjusted that reference ranges containing the cell. Nothing but an empty cell behaves exactly like an empty cell in every context. Jerry "Scott" wrote: Anyone, Is there a function where if the results of an equation are not above a value that you need, to make that cell blank? For instance, =A1*A2, if the answer to that equation is less than .01, just leave the cell blank. Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested Function | Excel Discussion (Misc queries) | |||
nested if function | Excel Worksheet Functions | |||
can you nested sum and round function within if function? | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |