EXCEL: If/Then Functions
Jun. 7th, 2009 04:50 pmOkay, I'm trying to figure out If/Then functions in Excel, and since the syntax is different from what I learned back in my basic programming days I need a bit of help.
What I want to do is to determine something like this:
If B4>14 and B5>15 and B6>13 then multiply F2 by 1.1 else just return the value of F2. Anyone know how I would do this and make it work in Excel?
What I want to do is to determine something like this:
If B4>14 and B5>15 and B6>13 then multiply F2 by 1.1 else just return the value of F2. Anyone know how I would do this and make it work in Excel?