Excel Forum Question.png
I need help with this formula please
If C7 <=-30% then I want an X, if >=-29.9% then I want a #, if <=30.1% I want a O
Excel Forum Question.png
I need help with this formula please
If C7 <=-30% then I want an X, if >=-29.9% then I want a #, if <=30.1% I want a O
Do you mean...
If C7 <=-30% then I want an X, if >=-29.9% then I want a #, if >=30.1% I want a O
I think you want something like this...
Formula:Please Login or Register to view this content.
or possibly this...
Formula:Please Login or Register to view this content.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Thank you a million Stephen.
Could you help with this one real quick.
I want it to count the "X" but subtract if the cell has an "O"
=COUNTIF(D7:T7,"X")
You were almost there. It should be...
Formula:Please Login or Register to view this content.
Thank you so so much! You rock!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks