Formula Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am trying to have my formula give people a score of 200 if they achieve
100% and zero for anything less than 100% on cell R2 but seem to be having
issues.

Here is what I have, what am I missing?

Much thanks

IF(R2>=100%,"200","0")
 
What issues are you having? Your formula works for me but returns text
representations of numbers. If you want to use the 200 or 0 in calculations
then remove the quotes.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
That will give you 0 and 200 as text strings, not as numbers. Ditch the
quote marks.
 
Back
Top