Microsoft Support

Microsoft Home Page

Sign in

Select the product you need help with

Select a solution

Function for counting data only not formula
Hello, I cannot find a function that will count only the data being displayed in a cell. I tried CountA but because there is a formula on the blank cells it counts them as well. I have a list of names
What formula or function do I use to create a formula where if the value in F8 is less than 11.58 then it needs to be changed to 11.58
What formula or function do I use to create a formula where if the value in F8 is less than 11.58 then it needs to be changed to 11.58
How can I set a formula or a function to a cell like below
How can I set a formula or a function to a cell like below, for example I want the formula to check If there's any value in cell B4,I mean if somthing is written in B4,add 1 to B5,for example if
Locking a formula or function to a cell
How do I lock a formula or a function to specific cells, so that even after I sort and these cells move to different rows, the formula or function still picks up on those specific cells?
Function or Formula to Lookup a Value
Hi Everyone, I’m trying to find a good way formula or function to review a store row on SHEET A and return a 1 if true or a 0 if false on SHEET B if the particular part is available. I’ve searched and