| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help with formula to make cell blank
In T2 I have this formula:
=IF((N2<(U2-80)),U2-(N2+80),0) In U2 I have this formula: =IF(A20,VLOOKUP(A2'SHEET1'!$A$2:$C$288,3,FALSE)*1 0,"") Once I enter a number in A2, all formulas work fine and I get the desired result. However, when A2 is blank, #VALUE is displayed in T2 because of formula in U2. I need T2 to be blank until a number is entered in A2. I'm sure it is a fairly easy fix but I can't work it out. Can someone help with this? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| How do identify a blank cell in a formula | Excel Discussion (Misc queries) | |||
| how do i create a blank cell in excel using a formula | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
