How do I create a conditional formula in excel?
- 1 Answers
- 765 Views
- I also Faced
- E-Mail Answers
Answer / Amresh Kumar Singh
"To create a conditional formula in Excel, use the IF function. Here is an example: IF(condition, value_if_true, value_if_false). Replace 'condition' with your criteria, 'value_if_true' with what you want to display if the condition is true, and 'value_if_false' with what you want to display if the condition is false. For example, IF(A1>50, "High", "Low") checks if cell A1 is greater than 50 and displays "High" if it is, or "Low" otherwise."
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I convert a formula to text?
How Cell Reference Is Useful In The Calculation?
How do you combine two formulas?
How do you insert a row on excel?
How do I customize the toolbar in excel 2016?
How do you write or in an excel formula?
Is there a way to allow the use of autofilter on a protected worksheet?
How do you link tabs in excel?
What is difference between worksheet and spreadsheet?
What is a lookup table in excel?
How do I install excel on my computer?
What is the best alternative to excel?
MS Excel Microsoft 
