View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SweetSin80
 
Posts: n/a
Default 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