Need help simplifying a formula if it's possible

I currently have this formula:

=IF(_CUST.TYPE="N",'Att. - 2014'!CJ10*13.8,IF(_CUST.TYPE="C",'Att. - 2014'!CJ10*10.8,IF(_CUST.TYPE="U",'Att. - 2014'!CJ10*13.8,IF(_CUST.TYPE="CU",'Att. - 2014'!CJ10*10.8,IF(ISBLANK(_CUST.TYPE)," ")))))

Basically:

If the Cust. Type is "N" or "U" then I want it to multiply [selected cell] by £13.80
If the Cust. Type is "C" or "CU" then I want it to multiply [selected cell] by £10.80

Is there a way I can simplify the above formula? Am I able to use the "OR" function? If so, how do I do it?

Thanks!

=IF(OR(D25="N",D25="U"),13.8,IF(OR(D25="C",D25="CU"),10.8,""))*'Att. - 2014'!CJ10

Try this in u r sheet

Punnam

THANK YOU!!!!! I've now solved it! I've done it as:

=IF(OR(BW10="N",BW10="U"),'Att. - 2014'!EQ10*13.8,IF(OR(BW10="N",BW10="U"),'Att. - 2014'!EQ10*10.8,IF(OR(BW10=0,EQ10=0)," ")))

And that now seems to work! Couldn't have done it without your help coz I didn't know how to set the OR function!

THANK YOU!!!!!!

@ martindwilson
No , he made mistake
This Correct one i think
=IF(OR(BW10="N",BW10="U"),'Att. - 2014'!EQ10*13.8,IF(OR(BW10="C",BW10="CU"),'Att. - 2014'!EQ10*10.8,IF(OR(BW10=0,EQ10=0)," ")))

Punnam

Ooops, yeah thanks for pointing that out. I did make a mistake (FYI I'm a 'she' not 'he')

I copied and pasted the first bit over and forgot to change the second bit from "N" & "U" to "C" & "CU".


Good spot!
Thanks!!!

Sally

Originally Posted by martindwilson

then fyi if you have the same cell = different things inside an OR()
you don't need to keep repeating the cell reference
=or(b10="x",b10="y",b10="z")
is the same as
=or(b10={"x","y","z"})

Thanks for that Martindwilson. I had that many people giving me formula options that I had to make sense of them in a way that would work for me with a bit of trial and error and missed that bit from "sixthsense". So thank you for pointing out that I'd repeated myself (that would have been disastrous once I started inputting figures) and thanks again for simplifying my formula even further for me.



BIG THANKS to everyone for helping me solve my formula issue!

Sally