Forum

Notifications
Clear all

NEED TO CALCULATE SOME VALUES USING LOGICAL FUNCTIONS

3 Posts
2 Users
0 Reactions
91 Views
(@harshaawl)
Posts: 2
New Member
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
(@harshaawl)
Posts: 2
New Member
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
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

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
Share: