| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if function with different criteria
this if you may enter other values
=IF(A1=0, 0, IF(A1=8, 0, IF(A1=7, 7.5, IF(A1=9, -7.5, "wrong value")))) or this if you r sure that there will be no other value entered =IF(A1=0, 0, IF(A1=8, 0, IF(A1=7, 7.5, -7.5))) "Haz" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if function with different criteria
try this
=IF(OR(E10=0,E10=8),0,IF(E10=7,7.5,IF(E10=9,-7.5,""))) On Oct 21, 7:08*pm, Haz wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if function with different criteria
thanks, this worked perfectly
"muddan madhu" wrote: try this =IF(OR(E10=0,E10=8),0,IF(E10=7,7.5,IF(E10=9,-7.5,""))) On Oct 21, 7:08 pm, Haz wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if function with different criteria
=(E10=0)*0+(E10=8)*0+(E10=7)*7.5-(E10=9)*7.5
-- Gary''s Student - gsnu200809 |
| Reply |
| 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 | |||
Hybrid Mode
