IF Function For Multiple Condition

rajendradk9

New Member
Joined
Aug 3, 2013
Messages
22
HI, I'm trying solution as mentioned below so need your support.
Having Column A B C D each are having Numeric value, based on this need two results as mentioned below in same cell

A+B-C*D<=0 Then Result should be 0 , A+B-C*D>0 Then Result should be A+B-C*D

For Example 20+40-6.45*20=0 , 60+20-6.45*2=67
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,719
Office Version
365
Platform
Windows
How about
=IF(A2+B2-C2*D2<0,0,A2+B2-C2*D2)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,719
Office Version
365
Platform
Windows
🤦‍♂️ new I was missing something
 

Watch MrExcel Video

Forum statistics

Threads
1,099,150
Messages
5,466,960
Members
406,513
Latest member
t0ny84

This Week's Hot Topics

Top