IF function

[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

 

[Frank Kabel]

Hi
you can't have both: The formula and a value in a cell using only
formulas

 

[Travis Benedict]

Try, assuming h is a valid reference to a cell or range, =IF(h=1,C9,r)
where r refers to the original number.