Tricky Formula Codes *** Urgent ***
 

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

Tricky Formula Codes *** Urgent ***
 

Try it this way:

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


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=511946

Tricky Formula Codes *** Urgent ***
 

Check this site out.
http://office.microsoft.com/en-us/as...091181033.aspx


TC
"SweetSin80" wrote:

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

Tricky Formula Codes *** Urgent ***
 

Or try this one (a little bit shorter ;) ):

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

"SweetSin80" wrote:

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