Related:
- If Statement
- Fenix internet on bank statement - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Excel if statement - Guide
- Sbi bank statement - Guide
- Excel if statement contains multiple words ✓ - Excel Forum
1 response
Nay,
Few ways to do it....
nest an OR statement in the IF statement
if(or(a2=10, a2=15,a2=39,etc)=true, b2*1.5, b2)
Other way to use the OR statement is to list 10,15,39,47,53,54,63... in separate cells (say d1 to d10) and use
if(or(d1:d10)=true, b2*1.5, b2)
Also, to use Lookup, again say use d1 to d10, and use lookup(a2, d1:d10), if true will return number, if false will return #N/A, so can also embed this in ISNA
if(isna(lookup(a2, d1:d10))=false, b2*1.5, b2)
There is a few other ways to do too, but either will work
Regards,
Few ways to do it....
nest an OR statement in the IF statement
if(or(a2=10, a2=15,a2=39,etc)=true, b2*1.5, b2)
Other way to use the OR statement is to list 10,15,39,47,53,54,63... in separate cells (say d1 to d10) and use
if(or(d1:d10)=true, b2*1.5, b2)
Also, to use Lookup, again say use d1 to d10, and use lookup(a2, d1:d10), if true will return number, if false will return #N/A, so can also embed this in ISNA
if(isna(lookup(a2, d1:d10))=false, b2*1.5, b2)
There is a few other ways to do too, but either will work
Regards,
Nov 17, 2008 at 09:36 PM