Need help with Excel formula

793 Views 2 Replies 2 Participants Last post by kpage21, May 31, 2017

kpage21

Discussion Starter · May 31, 2017

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.

See less See more

Save

Status: Not open for further replies.

1 - 3 of 3 Posts

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

See less See more