Simple one (I'm sure) for you on here. I have a formula, =IF(C2=1,D2*C5+E2*E5,0) that's works just fine if C2=1. Is it possible to have a single formula that would work if C2 was to equal 2,3 or 4?
Basically if I could I would have 4 formulas in the same cell they would be =IF(C2=1,D2*C5+E2*E5,0) =IF(C2=2,D2*C6+E2*E6,0) =IF(C2=3,D2*C7+E2*E7,0) =IF(C2=4,D2*C8+E2*E8,0)
Thanking you in anticipation
Last edited by Marvo; 04-11-2016 at 05:50 AM.
well this should do it ... =IF(C2=1,D2*C5+E2*E5,IF(C2=2,D2*C6+E2*E6,IF(C2=3,D2*C7+E2*E7,IF(C2=4,D2*C8+E2*E8,0)))
(not tested)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
I've just tried this
=IF(B2=1,C2*C5+D2*D5)=IF(B2=2,C2*C6+D2*D6)=IF(B2=3,C2*C7+D2*D7)=IF(B2=4,C2*C6+D2*D6,0)
But it results in FALSE
but that isn't what I gave you. this is what I gave you...
=IF(C2=1,D2*C5+E2*E5,IF(C2=2,D2*C6+E2*E6,IF(C2=3,D2*C7+E2*E7,IF(C2=4,D2*C8+E2*E8,0)))
That works a treat. Thank you very much.
Sorry, I posted my first reply before I saw your response. Again, thank you.
You're welcome! Glad it worked for you. And thank you for the rep!
One way:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
OrFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks