| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Tricky 'Find Maximum' problem seeks formula | Excel Worksheet Functions | |||
| Date stamp formula results? Tricky problem? | Excel Discussion (Misc queries) | |||
| Urgent - Formula for incr/decrease of 5 cells | Excel Worksheet Functions | |||
Linear Mode
