IF AND formulas

[Michaelbbeck]

Hi everyone and thank you all in advance

I've learnt heaps off here kudos to all.

My question is simple I think but need help. I need a formula that takes a few events and returns.

My customers have the option of either an XF or AU machine. They both have different annual support contracts, but we also offer quarterly contract. When I create an ROI id like to be able to select (from the drop-down which I've created). The costs and definitions are below

the machine (XF or XU)
and then the contract type and
return the correct figure.
BUT the final number must go into the same cell of the worksheet regardless of the combination.

I've tried to work it out but I'm in a vortex now of confusion

Many thanks in advance

Michael

SynMed XF ROI

Contract	XF	XU
Annually	$ 22,000	$ 44,000
Quarterly	$ 6,000	$ 12,000

 

[Saba Sabaratnam]

You could use this formula in Cell F4

=INDEX($B$2:$C$3,MATCH($F$2,$A$2:$A$3,0),MATCH($F$3,$B$1:$C$1,0))

Kind regards

saba

 

[Michaelbbeck]

Hi

You could use this formula in Cell F4

=INDEX($B$2:$C$3,MATCH($F$2,$A$2:$A$3,0),MATCH($F$3,$B$1:$C$1,0))

View attachment 41797

Kind regards

saba

Hi Saba Thanks so much ill try it out and let you know