| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if function with different criteria
hi,
i need an if function I think that will do the following:- if E10 is 0 then E20 shows 0 or blank If E10 is 8 then E20 shows 0 If E10 is 7 then E20 shows 7.50 If E10 is 9 then E20 shows -7.50 I have tried to get an if function to do this but can't get it to work properly, maybe i need a different function? Any help would save me a great deal of time and would be appreciated. Thanks Haz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to add one more criteria to this function | Excel Worksheet Functions | |||
| Sum If function with 2 criteria | Excel Worksheet Functions | |||
| If Function. How to Add more criteria | Excel Worksheet Functions | |||
| Function for more than 1 criteria | Excel Worksheet Functions | |||
| How do I use the SUM IF function with two different criteria. S. | Excel Worksheet Functions | |||
Threaded Mode
