paladin
March 4th, 2009, 08:43 PM
For an EC problem, my professor has asked us to come up with an excel spread sheet. I wont go into details about what but im stuck.
I need an =IF() statement, heres what I have so far... =IF(E5>E4,E5,"false"). Now, if the statement is false, I want to keep track of how many times. So basically, I want to the statement to look like this =IF(E5>E4,E5,"false"&N4+1), but it doesnt work. Does any one know how to make multiple outputs for a value?
Ive tried +, &, and a ',', and they all output "false + 1".
I need an =IF() statement, heres what I have so far... =IF(E5>E4,E5,"false"). Now, if the statement is false, I want to keep track of how many times. So basically, I want to the statement to look like this =IF(E5>E4,E5,"false"&N4+1), but it doesnt work. Does any one know how to make multiple outputs for a value?
Ive tried +, &, and a ',', and they all output "false + 1".