Combining multiple IF(OR combinations

[Daphnehull]

I'm trying to build an excel sheet to make my job a lot easier and I have figured out the individual if or statements but I need them all combined into a giant formula can anyone help?

=IF(OR(E1879="M3-1",E1879="M4-1",E1879="V1-1",E1879="V1-2"),F1879,"")

=IF(OR(E1879="V2-1",E1879="V2-2",E1879="V3-1",E1879="V3-2"),(F1879-F1878),"")

=IF(OR(E1879="M1-1",E1879="M1-2",E1879="M2-1",E1879="M2-2"),((148.8-F1879)/148.8)*207,"")

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(OR(E1879="M3-1",E1879="M4-1",E1879="V1-1",E1879="V1-2"),F1879,IF(OR(E1879="V2-1",E1879="V2-2",E1879="V3-1",E1879="V3-2"),(F1879-F1878),IF(OR(E1879="M1-1",E1879="M1-2",E1879="M2-1",E1879="M2-2"),((148.8-F1879)/148.8)*207,"")))

 

[Daphnehull]

Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.