ExcelBanter - IF OR Formula Help

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF OR Formula Help (https://www.excelbanter.com/excel-discussion-misc-queries/170755-if-formula-help.html)

Karen Smith

IF OR Formula Help

I'm having trouble getting this formula to work, what am I doing wrong?

=IF(OR(C11={"None";""}),"",VLOOKUP(A11&"-"&F11&"-"&G11&"-"&b11&"-"&c11,'Writing Charges (2)'!f3:g237),2,0)*I11)

Bob Phillips

IF OR Formula Help

=IF(OR(C11={"None";""}),"",VLOOKUP(A11&"-"&F11&"-"&G11&"-"&B11&"-"&C11,'Writing
Charges (2)'!F3:G237,2,0)*I11)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Karen Smith" wrote in message
...
I'm having trouble getting this formula to work, what am I doing wrong?

=IF(OR(C11={"None";""}),"",VLOOKUP(A11&"-"&F11&"-"&G11&"-"&b11&"-"&c11,'Writing
Charges (2)'!f3:g237),2,0)*I11)

All times are GMT +1. The time now is 06:55 PM.