LinkBack URL
About LinkBacks
Hello every one,
i have this spreadsheet with students score, their performance is low and i want to add constant value say 20 marks to only the cells with red that is the cells that has less than 49 marks.
please how can i go about it.
Hello every one,
i have this spreadsheet with students score, their performance is low and i want to add constant value say 20 marks to only the cells with red that is the cells that has less than 49 marks.
please how can i go about it.
Last edited by oluagbe1; 04-17-2017 at 04:03 PM.
Enter this formula into X8
Formula:
Please Login or Register to view this content.
Fill down and to the right to AG98
Copy X8:AG98 and paste special values into E8
Clear x8 to AG8
As a Macro
Please Login or Register to view this content.
Last edited by mehmetcik; 04-17-2017 at 02:56 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Creating 2 named cells to allow you to amend both values later
Results in attached workbook in sheet "Amended"
B1 = 20, and is named "AddThis
C1 = 49 and is named "LessThanThis"
Take a copy of the worksheet and put this formula in cell E8 and copy it down and across to the relevant cells
Formula:Please Login or Register to view this content.
Your conditional formatting says <= 49, so I have used that too
I do not think you want to add 20 to something that was not completed - so I excluded anything < 1
Last edited by kev_; 04-17-2017 at 03:23 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Originally Posted by mehmetcik
Enter this formula into X8
Formula:Please Login or Register to view this content.
Fill down and to the right to AG98
Copy X8:AG98 and paste special values into E8
Clear x8 to AG8
As a Macro
Please Login or Register to view this content.
this worked well for me, i appreciate you a great deal.
thank you also for the correction on saying please and thank you.
i sincerely do appreciate and you saved my day.
than you again
Creating 2 named cells to allow you to amend both values later
Results in attached workbook in sheet "Amended"
B1 = 20, and is named "AddThis
C1 = 49 and is named "LessThanThis"
Take a copy of the worksheet and put this formula in cell E8 and copy it down and across to the relevant cells
Formula:Please Login or Register to view this content.
Your conditional formatting says <= 49, so I have used that too
I do not think you want to add 20 to something that was not completed - so I excluded anything < 1
This method is mind blowing...
i love it much, you are amazing
thank you very much.
i love this work you just did.
God bless you much.
You are welcome
Thanks for marking the thread as solved
You do not need to "quote" complete posts - it fills the thread with unnecessary clutter.
Simply reply to the previous comment etc.
For clarity it is sometimes helpful to quote:
- the post#
- a portion of a post
- @MemberName if more than one member is taking part in the thread
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks