| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's wrong with this formula?
Ray wrote:
=IF(B270,+B27:B32-B28,"") Want to add B27-B32 and subtract B28 if B27 is 0. If not I want the cell to stay blank. As soon as I enter a number in B27 the cell shows ###. The cell is wide enough and the cell format is general. Working only with numbers Thanks Do you mean this: =IF(B270,SUM(B27:B32)-B28,"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula returning "A value used in the formula is of the wrong dat | Excel Worksheet Functions | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| What's wrong with this formula? | Excel Worksheet Functions | |||
| Can anyone tell me what is wrong with this formula please?! | Excel Worksheet Functions | |||
| What is wrong in formula. | Excel Discussion (Misc queries) | |||
Threaded Mode
