Excel Forum

NEED TO CALCULATE SOME VALUES USING LOGICAL FUNCTIONS

HARSHA KUMAR

New Member

Members

Forum Posts: 2

Member Since:
May 8, 2021

Offline

May 8, 2021 - 4:50 pm

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

HARSHA KUMAR

New Member

Members

Forum Posts: 2

Member Since:
May 8, 2021

Offline

May 8, 2021 - 4:51 pm

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)"

Anders Sehlstedt

Eskilstuna, Sweden

VIP

Members

Trusted Members

Forum Posts: 871

Member Since:
December 7, 2016

Offline

May 9, 2021 - 8:35 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

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Andy Kirby, Kim Knox, Darrell Hodge, Tiffany Kang

Guest(s) 11

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 871

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

Jessica Stewart: 204

A.Maurizio: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

Maria Conatser

Jefferson Granemann

Glen Coulthard

Nikki Fox

Rachele Dickie

Raj Mattoo

Mark Luke

terimeri dooriyan

Jack Aston

AndyC

Forum Stats:

Groups: 3

Forums: 24

Topics: 6221

Posts: 27285

Member Stats:

Guest Posters: 49

Members: 31908

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen