Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula???
Hi,
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 advise! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula???
Try this:
=IF(SUMPRODUCT(--(O5:O20O22-4*D3))0,"BAD DATA",0) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "John Sofillas" wrote in message ... Hi, 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 advise! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|