View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default hi, new value formula question

Try something like this:

=IF(OR(N101.749,N10=0),0,(1.75-N10)*200)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"RayB" wrote:

ok, you all were perfect last question. Now I have a three way value I'm
trying to imput. The formula I'm using presently is this:
=IF(N101.749,0,(1.75-N10)*200)
It works fine.
The problem that I have is this - If N10=0 I'd like the answer to be 0.
If N10 1.75 I'd like the
answer to be 0.
If N10 is not 0, but is less
than 1.75 then I want to use the 1.75-N10*200 formula.
Thanks!