View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aglet aglet is offline
external usenet poster
 
Posts: 2
Default Again for Formula that isn't working...Had response but not workin

If I understand you correctly, try

=MAX(B2-17,0)

----------------
"jeannie v" wrote in message
...
Hi Experts:

I had requested assistance earlier today and thought it was working, but
as
I got into the doc, it's not working as it should...

I have 87 Lines in the Excel doc

I want each line to:

B2 is a variable (we'll say 20)17(17 is constant )= difference between 20
&
17 (3)in C2 but I want it to return 0 if B2 is <=17 in C2

The solution given to me before works for 1 of my lines, but it doesn't
work
for all the variables in B2.

Can anyone give me additional help? Thank you so much
--
jeannie v