Forum Discussion

Copper Contributor

Apr 09, 2021

Solved

Addition to an existing formula

Hi, I have the following formula that works well: =(IF(AND(H13=1,E33=""),INDEX(Sheet1!C4:H30,MATCH((E31),Sheet1!A4:A30),MATCH(H15,Sheet1!C3:H3,0)),IF(H13=2,INDEX(Sheet1!L4:Q30,MATCH((E31+E33)...

excel

Riny_van_Eekelen
Apr 11, 2021
Scott Miller Sorry, I missed the "2 or more" part your original question. Change the latter part of the extras to :
(H14>=2)*492
Any number greater than or equal to 2 will add 492.

Scott Miller

Copper Contributor

Apr 11, 2021

Riny_van_Eekelen

Thanks for the add, the only thing it seems to get caught up on is if you place more than 2 in H14 then it reverts back to the answer of have nothing in H14?

Is there a way of showing the answer with 1 in H14 (which it does now) and the answer with 2 (which it does now), but leave the answer of having 2 if there is a value higher the 2?

So if you place a 6 (or any number above 2) in H14 it would only show the answer of having 2 in H14?

Cheers Scott

Riny_van_Eekelen

Platinum Contributor

Apr 11, 2021

Scott Miller Sorry, I missed the "2 or more" part your original question. Change the latter part of the extras to :

(H14>=2)*492

Any number greater than or equal to 2 will add 492.

Scott Miller
Copper Contributor
Apr 11, 2021
Perfect - Thank you. 🙂