Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Text When Blank
Lets see if i can explain this. I am doing a certified weight cert and you input values on one sheet and vlookup functions call the information onto the actual certificate. There are three values that we are working with, Gross Weight, Tare Weight, and Net Weight. Gross is F2, Tare is G2 and Net is H2. When a value is only entered in Tare, Net says TARE ONLY as the function reads =IF((F2-G2)0, F2-G2, "TARE ONLY") I now need F2 to read "TARE ONLY" as well if F2 is blank. Conversly, if G2 is blank, F2 and H2 need to read "GROSS ONLY" Thanks for your help. -- Chuck N ------------------------------------------------------------------------ Chuck N's Profile: http://www.excelforum.com/member.php...o&userid=27057 View this thread: http://www.excelforum.com/showthread...hreadid=497626 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Blank Line | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Blank cell conversion to text | New Users to Excel |