| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What's wrong with this formula?
=IF(B270,+B27:B32-B28,"")
Working with numbers only. If false I want the cell to be blank. I'm getting #### Doesn't help to widen cell format of cell is general Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What's wrong with this formula?
hi
try =(B270,sum(B27:B32)-B28,"") regards FSt1 "Ray" wrote: =IF(B270,+B27:B32-B28,"") Working with numbers only. If false I want the cell to be blank. I'm getting #### Doesn't help to widen cell format of cell is general Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What's wrong with this formula?
Are you trying to add the numbers B27 to B32, omitting B28 ?
If so, try this: =IF(B270,SUM(B27:B32)-B28,"") Hope this helps. Pete On Feb 16, 4:25*pm, Ray wrote: =IF(B270,+B27:B32-B28,"") Working with numbers only. If false I want the cell to be blank. I'm getting #### Doesn't help to widen cell format of cell is general Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What's wrong with this formula?
That worked!!
Thank you very much!! "Pete_UK" wrote: Are you trying to add the numbers B27 to B32, omitting B28 ? If so, try this: =IF(B270,SUM(B27:B32)-B28,"") Hope this helps. Pete On Feb 16, 4:25 pm, Ray wrote: =IF(B270,+B27:B32-B28,"") Working with numbers only. If false I want the cell to be blank. I'm getting #### Doesn't help to widen cell format of cell is general Thanks . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What's wrong with this formula?
You're welcome, Ray, but please don't multi-post.
Pete On Feb 16, 8:24*pm, Ray wrote: That worked!! Thank you very much!! "Pete_UK" wrote: Are you trying to add the numbers B27 to B32, omitting B28 ? If so, try this: =IF(B270,SUM(B27:B32)-B28,"") Hope this helps. Pete On Feb 16, 4:25 pm, Ray wrote: =IF(B270,+B27:B32-B28,"") Working with numbers only. If false I want the cell to be blank. I'm getting #### Doesn't help to widen cell format of cell is general Thanks .- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What's wrong with this formula?
It would help if you told us what you want to accomplish.
You cannot use the range B27:B32 that way. Do you perhaps want: =if(b270,b27-b28,"") or, =if(b270,b27-b32-b28,"") ? Regards, Fred "Ray" wrote in message ... =IF(B270,+B27:B32-B28,"") Working with numbers only. If false I want the cell to be blank. I'm getting #### Doesn't help to widen cell format of cell is general Thanks |
| 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 | |||
| What is wrong with this formula? | Excel Worksheet Functions | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| What is wrong with formula? | Excel Worksheet Functions | |||
| What's wrong with this formula? | Excel Discussion (Misc queries) | |||
Hybrid Mode
