| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF & AND formulae
I am trying to say if I4 has something in it and K4=X, then put 200 in this
field, but if not see if I4 has something in it and J4 0 and L= YES then times J4 by 1.5, if not put 0. my formulae is =+IF(AND(I40,K4=x),200,IF(AND(I40,J40,L=YES),J4 *1.5,0)) I get #NAME? can someone help me get this right please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
| Help with formulae | Excel Discussion (Misc queries) | |||
| age formulae | Excel Discussion (Misc queries) | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
| Formulae | Excel Discussion (Misc queries) | |||
Threaded Mode
