| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Function ignoring rest of formula
I have a formula, it reads"
=A9&"\r"&B9*100&"\r"&C9&"\r"&D9&"\r"&F9&"\r"&G9*-100&"\r"&H9 The formula is being copied into a data entry system that converts the info into different columns. The problem is if C9= 0 then I need the "\r" to not be there and continue on with the rest of the formula. Is there anything I can do? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel invoke REST service function with Xpath fn parse result! | Excel Worksheet Functions | |||
| Formula function for ignoring cells/results equal to 0 (zero) ? | Excel Discussion (Misc queries) | |||
| debug repeat entries with a random function and erase the rest | Excel Programming | |||
| How can I sort workdays formula with the rest of the worksheet | Excel Discussion (Misc queries) | |||
| Only see name box and formula box where is the rest? | Excel Discussion (Misc queries) | |||
Threaded Mode
