Tricky Formula Codes *** Urgent ***

[SweetSin80]

This one works...
=IF(G5="S",H5*0.1,H5*0.05)

But if I want to add another, ("W",H5*0.15) I'm trying this one...

=IF(G5=("W",H5*0.15),("S",H5*0.1),H5*0.05) NOT WORKING

Need help makin it work, many Thx

 

[Cutter]

Try it this way:

=IF(G5="S",H5*0.1,IF(G5="W",H5*0.15,H5*0.05)

 

[TC]

Check this site out.
http://office.microsoft.com/en-us/assistance/HP052091181033.aspx


TC

 

[Eric_MUC]

Or try this one (a little bit shorter ):

=H5*IF(G5="W",0.15,IF(G5="S",0.1,0.05))