Combining IF statements

**dempsey29** · 09-02-2020, 07:23 AM

Hello,

I have two IF formulas that I would like to combine - please see attached excel doc.

If C2 = "Blue" =IF(E2="","",IF(((((((B2*(C2-2))*1.02)/(E2-1))/1.02)+(-B2))+(B2))/(B2)<0.65,"NO BET",((C2-1)/(E2-F2)*B2)))
If C2 = "Green" =IF(E3="","",IF(((((((B3*(C3-2))*1.02)/(E3-1))/1.02)+(-B3))+(B3))/(B3)<0.65,"NO BET",(C3/(E3-F3)*B3)))

The formulas are the same up until after "NO BET". I would like this to be one formula only so that I can change value C2 and it calculates correctly.

Many thanks, Alexya

Cross-posted https://www.mrexcel.com/board/thread...mulas.1144659/

**davsth** · 09-02-2020, 08:42 AM

Your formulas do not work in the current form, you even have them as text in the example. Why not say in English what you want

it will also give an idea of presedence

**dempsey29** · 09-02-2020, 08:52 AM

The formulas do work, they are in cells F2 & F3 in the attachment.
I would like to combine both formulas so that when I change the text in C2 to "Blue" or "Green", it drives out the correct result.
Thanks

**6StringJazzer** · 09-02-2020, 11:59 AM

Welcome to the Forum dempsey29!

Please note that if you post the same question elsewhere we require a link. I have provided it for you since it's your first post.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

Combining IF statements

LinkBack

Thread Tools

Rate This Thread

Display

Combining IF statements

Re: Combining IF statements

Re: Combining IF statements

Re: Combining IF statements

Thread Information

Users Browsing this Thread

Similar Threads

Combining Two Different IF AND statements with an ELSE

[SOLVED] Combining IF Statements

[SOLVED] Combining 3 IF/AND statements with OR

Combining IF Statements with AND OR

combining various IF statements

combining two if then statements

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions