Question to all

[Iftikharkazmi]

I make one Sheet
Iffi is player i add daily points in iffi's Cell
and i make another Separate Sheet to add formula when iffi make 500 or 500+ points to formula cell Show Five hundrad when 1000 show thousand which formula to used plz ans me quickly plzzzzzzzzzzzzz​

 

[RCBricker]

I make one Sheet
Iffi is player i add daily points in iffi's Cell
and i make another Separate Sheet to add formula when iffi make 500 or 500+ points to formula cell Show Five hundrad when 1000 show thousand which formula to used plz ans me quickly plzzzzzzzzzzzzz​

First a couple things. DO NOT produce multiple threads for the same question. Most people will stop helping you if they see you do this as there is no reason to waste their time if someone is helping in the other thread.

Please do not FONT color your questions. It makes them hard to read.

I am not sure if this is what you want. But try this.


if IFFI's score is maintained on sheet1 cell B1 and the summary is on sheet2 cell B1 then try this:

=IF(Sheet1!B1<500,"",IF(Sheet1!B1>=1000,1000,500))