Excel sheet to add conditions

Devlin0605 - Dec 5, 2017 at 06:44 AM - Latest reply: ac3mark 8377 Posts Monday June 3, 2013Registration dateModeratorStatus December 15, 2017 Last seen
- Dec 5, 2017 at 05:01 PM
Hello,

I am trying to do an excel sheet, so that if i put an x in a cell it adds the value from the top row. For a window schedule, where I assign values to certain conditions, and if that condition exists it adds the value automatically and put the sum at the end of the row. Is this possible?


See more 

1 reply

Reply to this topic
ac3mark 8377 Posts Monday June 3, 2013Registration dateModeratorStatus December 15, 2017 Last seen - Dec 5, 2017 at 05:01 PM
0
Helpful
OK, so the syntax fo rIF is as follows:

=IF(logic_test,True, False)

So, your example would look like:

=IF(A1="X", place_value,"")


Then in a module:

sub place_value()
place_value=ThisWokbook.Worksheet("Sheet10").Cells(1,1).Value
end sub



So, the above solution will take the Data on Sheet10, cell A1, and place it into what ever cell has the If formula that calls the subroutine of place_value()

Have Fun!
Respond to ac3mark