ExcelBanter - a problem with if invovling a range of cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - a problem with if invovling a range of cells (https://www.excelbanter.com/excel-worksheet-functions/34578-problem-if-invovling-range-cells.html)

Anthony

a problem with if invovling a range of cells

If the date in D7 equals any of the dates showing in E29 to e41 then multiply
the corresponding row in the c column by b5 and add them together to appear
in this cell

=IF('Cattle Budget'!D7='Cattle Mvts'!E29:'Cattle Mvts'!E41,'Cattle
Mvts'!C29*'Feedlot Assumptions'!B5,0)

Biff

See other post

Biff

"Anthony" wrote in message
...
If the date in D7 equals any of the dates showing in E29 to e41 then
multiply
the corresponding row in the c column by b5 and add them together to
appear
in this cell

=IF('Cattle Budget'!D7='Cattle Mvts'!E29:'Cattle Mvts'!E41,'Cattle
Mvts'!C29*'Feedlot Assumptions'!B5,0)

All times are GMT +1. The time now is 02:57 PM.