ExcelBanter - Tricky Formula Codes ***Urgent***

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Tricky Formula Codes ***Urgent*** (https://www.excelbanter.com/excel-discussion-misc-queries/71362-tricky-formula-codes-%2A%2A%2Aurgent%2A%2A%2A.html)

SweetSin80

Tricky Formula Codes ***Urgent***

This one works fine, =IF(G2="S",H2*0.1,H2*0.05) But if I want to add in
another for "W" this is what I am trying, but it is not working....

=IF(G2=("W",H2*0.15),("S",H2*0.1),H2*0.05)

Help needed and very appreciated!

Elkar

Tricky Formula Codes ***Urgent***

Try this:

=IF(G2="S",H2*.01,IF(G2="W",H2*.15,H2*.05))

HTH,
Elkar

"SweetSin80" wrote:

This one works fine, =IF(G2="S",H2*0.1,H2*0.05) But if I want to add in
another for "W" this is what I am trying, but it is not working....

=IF(G2=("W",H2*0.15),("S",H2*0.1),H2*0.05)

Help needed and very appreciated!

Tricky Formula Codes ***Urgent***

try
=IF(G2="W",H2*0.15,i,if(G2="S",H2*0.1,H2*0.05))

"SweetSin80" wrote:

This one works fine, =IF(G2="S",H2*0.1,H2*0.05) But if I want to add in
another for "W" this is what I am trying, but it is not working....

=IF(G2=("W",H2*0.15),("S",H2*0.1),H2*0.05)

Help needed and very appreciated!

All times are GMT +1. The time now is 07:51 AM.