Solved Need help with Excel formula

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

kpage21

Thread Starter
Joined
May 31, 2017
Messages
2
I attached a picture of the spreadsheet/current formula. I would like to add another formula into cell K101 so that when a value is entered into M101, K101 goes to 0.
 

Attachments

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,490
a spreadsheet is better to load then a picture

Just add and IF to your formula

"=YourFormula"
as it is now
change to
=IF( M101<>"" , 0, YourFormula)

that assumes that the cell is blank and then a value is added

if you want to detect that the cell HAS changed vlaue - you will need VBA to do that , not my area, i'm afraid

Wayne
 

kpage21

Thread Starter
Joined
May 31, 2017
Messages
2
Thanks! I will keep that in mind for next time. I had a brainfart, and realized that I could just subtract M101 from K101 in the current formula.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top