Conditional Formula

Y

Yeroc

Fairly new to using formula's

I am trying to develope a formula that will:
In cell B2 = A2 - A3 but if B2=A2 I want the value to be "0".


A B
1 33 11
2 22 22
3 0

Please help.
 
J

JoAnn Paules

You have to add another column. Using your example and adding a column C:
Cell C2 would contain the formula =IF(B2=A2,"0",(A2-A3))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Conditional Formula 1
Excel - Wich Function should I use? 1
Transfer data between two tables 3
Newbie Help - IF Yes No Function 0
find oldest date with a condition 4
Insert Index into a Table 1
Find value based on two lookup values 2

Top