LinkBack URL
About LinkBacks
I am trying to get excel to award a 1 point in a cell when a diffrent cell reaches a certin value or above
ie
A1 reaches 60% or above... I then want excel to place the number 1 in cell B1.
any help would be great thanks
Excel to award a point ??
I am trying to get excel to award a 1 point in a cell when a diffrent cell reaches a certin value or above
ie
A1 reaches 60% or above... I then want excel to place the number 1 in cell B1.
any help would be great thanks
Last edited by daniel.thomas10; 04-21-2010 at 06:54 PM.
=if(A1>=.6,1,0)
welcome
click on the * Add Reputation if this was useful or entertaining.
that is just giving me the word TRUE not a number 1
TRUE has the value 1 so it is some formatting issue on your sheet. Just try it on a new blank sheet.
GREAT thanks so much
If thatt is it please mark the thread as solved.You should have a message from me on how to do that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks