complex if statement
column B contains a value of either "F" or "H" or blank
column C contains a value of either "A" or B" or blank columns D-G contain various numeric values In column A here is what I want to be returned: if column B="F" return the value of 20; if column B="H" return the value of 10; if column B is blank, add together the values in columns D-G AND if column C="A" return the value of 20; if column C="B"= return the value of 10; if colum C is blank, add together the values in columns D-G (and column B) |
complex if statement
Since you havent mentioned about data in both Columns B and C; I assume you
will have either colB or ColC will have data...Try the below formula in Cell A1 and copy down as required (all in one line) =IF(OR(B1&C1="F",B1&C1="A"),20, IF(OR(B1&C1="H",B1&C1="B"),10,SUM(D1:G1))) If this post helps click Yes --------------- Jacob Skaria "kdel1201" wrote: column B contains a value of either "F" or "H" or blank column C contains a value of either "A" or B" or blank columns D-G contain various numeric values In column A here is what I want to be returned: if column B="F" return the value of 20; if column B="H" return the value of 10; if column B is blank, add together the values in columns D-G AND if column C="A" return the value of 20; if column C="B"= return the value of 10; if colum C is blank, add together the values in columns D-G (and column B) |
All times are GMT +1. The time now is 04:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com