IF function

  • Thread starter Thread starter brett4098
  • Start date Start date
B

brett4098

I am having trouble with this function. Here is the formula i am using
IF(h=1,C9). What is going on is that when h is not equal to 1 i
returns a FALSE reading. Instead of the FALSE statement, i would lik
the original number to stay. I want to keep changing h and have th
readout look something like this:


1 -143
2 -182
3 -198
4 -199
5 -190

but like i said, when i change h to something other than the number i
the formula it gives me the FALSE reading. Can you help. You can emai
be at brett.richard@bakeroiltools. Thank
 
Try, assuming h is a valid reference to a cell or range, =IF(h=1,C9,r)
where r refers to the original number.
 
Back
Top