HELP!!!

  • Thread starter Thread starter vanessa
  • Start date Start date
V

vanessa

I AM WORKING ON A SPREADSHEET USING THE FORMULA
=IF(F2016>0,"0.00",E2016)

THIS IS MAKING ME CRAZY - I AM COPYING THE FORMULA FROM
CELL TO CELL - IT WILL CALCULATE CORRECTLY ON ONE LINE
THEN NOT ON THE NEXT - I HAVE CHECKED EVERYTHING I CAN
THINK OF. PLEASE HELP ME!
 
vanessa said:
I AM WORKING ON A SPREADSHEET USING THE FORMULA
=IF(F2016>0,"0.00",E2016)

THIS IS MAKING ME CRAZY - I AM COPYING THE FORMULA FROM
CELL TO CELL - IT WILL CALCULATE CORRECTLY ON ONE LINE
THEN NOT ON THE NEXT - I HAVE CHECKED EVERYTHING I CAN
THINK OF. PLEASE HELP ME!
Click to expand...

Hi Vanessa,

I think you want an absolute reference instead of a relative one, try,

=IF($F$2016>0,"0.00",$E$2016) and then copy

Hope this helps!
 
Hi
first: please don't post in all UPPER case (difficult to read and
considered as shouting)

For your question:
- If you want to return a number, change the formula to
=IF(F2016>0,0.00,E2016)

- Also this formula looks o.k. What exact error did you get?
 
Back
Top