| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expanding Range in Formula?
The formula below works the way I want it to for cell O5. How can I
open this formula up for a range of cells O5:O20? =IF(O5(O22-4*D3),"Bad Data",0) As always, much appreciated for the advice. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Expanding Range in Formula?
=IF(Sumproduct(--(O5:O20(O22-4*D3))),"Bad Data",0) This will return "Bad Data" if any value in O5:O20 is greater thanO22-4*D3 -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122849 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Expanding Range in Formula?
Hello-
Can I ask what is the purpose of the two dashes in the formula? Thanks -- OneFineDay "NBVC" wrote: =IF(Sumproduct(--(O5:O20(O22-4*D3))),"Bad Data",0) This will return "Bad Data" if any value in O5:O20 is greater thanO22-4*D3 -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122849 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Expanding Range in Formula?
Double unary minus:
a.. http://www.mcgimpsey.com/excel/formulae/doubleneg.html b.. http://xldynamic.com/source/xld.SUMPRODUCT.html -- David Biddulph "M Thompson" wrote in message ... Hello- Can I ask what is the purpose of the two dashes in the formula? Thanks -- OneFineDay "NBVC" wrote: =IF(Sumproduct(--(O5:O20(O22-4*D3))),"Bad Data",0) This will return "Bad Data" if any value in O5:O20 is greater thanO22-4*D3 -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122849 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Expanding Range in Formula?
On Aug 6, 3:12*am, "David Biddulph" <groups [at] biddulph.org.uk
wrote: Double unary minus: * a..http://www.mcgimpsey.com/excel/formulae/doubleneg.html * b..http://xldynamic.com/source/xld.SUMPRODUCT.html -- David Biddulph "M Thompson" wrote in message ... Hello- Can I ask what is the purpose of the two dashes in the formula? Thanks -- OneFineDay "NBVC" wrote: =IF(Sumproduct(--(O5:O20(O22-4*D3))),"Bad Data",0) This will return "Bad Data" if any value in O5:O20 is greater thanO22-4*D3 -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile:http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh....php?t=122849- Hide quoted text - - Show quoted text - Thanks again for the great support. Formula was exactly what I was looking for. Much appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expanding a formula from a cell to a range | Excel Discussion (Misc queries) | |||
| Expanding a named range | Excel Worksheet Functions | |||
| expanding the size of all cells in a range | Excel Discussion (Misc queries) | |||
| Expanding a Range Automatically | Excel Discussion (Misc queries) | |||
| expanding a range of numbers | Excel Discussion (Misc queries) | |||
Linear Mode
