| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's wrong with this formula?
=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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What's wrong with this formula?
Did you check out your earlier post to see if there are any answers
there? Pete On Feb 16, 8:00*pm, 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What's wrong with this formula?
As pointed out in your earlier thread:
http://www.microsoft.com/office/comm...0-02cd45391cb5 You cannot simply stick an array of cells in the formula. I think you want: =IF(B270,SUM(B27:B32)-B28,"") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "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 |
|
#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,"") |
| Reply |
| 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) | |||
Linear Mode
