Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
91
Views
Topic starter
Hi Mam,
My query as follows:
A | Symbol | B = | C | |||||
1000 | / | 100 | 10 | |||||
1000 | / | 0 | #DIV/0! | |||||
Condition required: If A/B= C, which is > zero value then C should reflect, otherwise A value should refect |
Posted : 09/05/2021 2:50 am
Topic starter
Need solution for the above Condition.
If A/B= C,
"C" which is > zero value then C should reflect in the Column D , otherwise A value should reflect in the Column "D".
Tried to resolve the above function logically using "if" , But showing error.
" =If( A1/B1<=0, then A1 value should be the result in D1, otherwise A1/B1 value should result in D1)"
Posted : 09/05/2021 2:51 am
Hello,
You can find great info and examples on how to write IF formulas in the blog section.
Try this formula in D1.
=IFERROR(IF(A1/B1=C1,C1,A1),A1)
Br,
Anders
Posted : 09/05/2021 6:35 pm