IF statements
If(or(c=20, c=30), b2 *1.05, b*1.02)
Example of an OR statement. We can do “AND”, by replacing the OR.
Or statement includes the following:
Condition, value if true, value if false.
Vlookup value
=vlookup ( Look up value, look up range, col num, true or false)
If true, it isn’t exact; false is exact.
Colum num is what you want to [...]

Posted in Excel 2 Comments »