Help with IF Formula

[cmccambridge]

Hi,

I have a formula that calculates wages based off either choosing rate 1 or 2 in a drop down menu in cell H114. Do you know how to add to the formula if I add a rate 3 un the drop down menu??

Thanks

<colgroup><col></colgroup><tbody>
</tbody>

=IF(G114="","",IF(H114=1,G114*B109,B110*G114))

 

[Snakehips]

cmccambridge,

Assuming that your third rate is in cell B111 then try......

=IF(G114="","",IF(H114=1,G114*B109,IF(H114=2,B110*G114,B111*G114)))

Hope that helps.

 

[Gigi_]

Hi,

I have a formula that calculates wages based off either choosing rate 1 or 2 in a drop down menu in cell H114. Do you know how to add to the formula if I add a rate 3 un the drop down menu??

Thanks

<tbody>
</tbody>

=IF(G114="","",IF(H114=1,G114*B109,B110*G114))

Hi,
please test it

=IF(H114=1,G114*B109,IF(H114=2,B110*G114,IF(H114=3,XX*XX,"")))

 

[CWatts]

I' making some assumptions based on your code for how your workbook is set up, but one option that may be easier than having to go through nested if statements:

=IF(G114="","",G114*CHOOSE(H114,B109,B110))

To add a condition 3, just put a ,B111 after B110.

 

[Aladin Akyurek]

Hi,

I have a formula that calculates wages based off either choosing rate 1 or 2 in a drop down menu in cell H114. Do you know how to add to the formula if I add a rate 3 un the drop down menu??

Thanks

<tbody>
</tbody>

=IF(G114="","",IF(H114=1,G114*B109,B110*G114))

Looks like:

=IF(G114="","",G114*INDEX(B109:B111,H114))

 

[cmccambridge]

Works!
What would I do without the excel masterminds