Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Haz Haz is offline
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.excel.misc
RAZ RAZ is offline
external usenet poster
 
Posts: 120
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 747
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Haz Haz is offline
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need to add one more criteria to this function Gina[_2_] Excel Worksheet Functions 4 August 1st 08 07:03 PM
Sum If function with 2 criteria khaled shaheen Excel Worksheet Functions 4 April 24th 07 11:16 AM
If Function. How to Add more criteria Corey Excel Worksheet Functions 5 July 14th 06 08:57 AM
Function for more than 1 criteria rhani111 Excel Worksheet Functions 2 July 12th 05 05:21 AM
How do I use the SUM IF function with two different criteria. S. fish Excel Worksheet Functions 1 March 7th 05 07:21 PM


All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"