IF Function For Multiple Condition

rajendradk9

New Member
Joined
Aug 3, 2013
Messages
16
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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,439
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
38,439
Office Version
365
Platform
Windows
🤦‍♂️ new I was missing something
 

Watch MrExcel Video

Forum statistics

Threads
1,095,168
Messages
5,442,793
Members
405,197
Latest member
queryashish

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top