| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula result not displayin in cell
I've just created a nested/embedded logical formula, which appears okay
(i.e., with out errors), and the Function Arguments dialogue box displays an answer. However, the cell still displays zero and I don't understand why. If it's of any assistance, I have included the formula below: =ROUND(IF(AND(G34="Not Applicable",G35="No Allowance Made"),G36,IF(G34="Not Applicable",G36+G35,IF(G35="No Allowance Made",G36-G34,G36+G35-G34))),0) I've checked my formatting and this appears okay. Does anyone have any explanation as to why my result is not displaying? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Bar F9 Result differs from cell result??? | Excel Worksheet Functions | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Formula result in different cell | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
