Reply to thread

Message: <blockquote data-quote="Oompa" data-source="post: 4695591" data-attributes="member: 59252">I am trying to create a combat sheet in excel, now i am such a noob that i can't get a formula to work.. (im a formula noob)- Let's say i have a character with 35 hp, i want that to display in A1..- Lets say he takes 10 damage, i say: 10 in B1 (after i press enter i want the 10 to disappear..)- A1 changes to 25- So now column A1 shows 25 and B1 shows nothing..- Lets say my character spents a surge and heals 10 hp.- I enter 10 in cell C1 and C1 becomes empty and A1 changes back in 35..Rinse and Repeat.. oh and is it possible to make sure A1 never gets above 35?Is this possible? Yes? How?Oh and i ask it here.. cause here lurk the sheet wonder makers!</blockquote>