Forum Discussion
Problem with converting from C TO F
Basically I have multiple temperatures that could be entered and I always want it to read out as C. I put in two check boxes one for C and one for F. then I said IF C = true then just show temp but if F= TRUE then convert. Problem I'm having is when the F box is checked all the unused temps read as -17.7778. I tried just having it do the math instead of using CONVERT and it did the same thing. Any reason why it would do that? The unused temp slots are just blank so it must be trying to convert that blank to F but if it's blank there's nothing to convert so it should just read as 0 right?
2 Replies
Yes, blank cell is considered as zero in formula.
- Okay I just answered my own question. It's assuming the 0 in the blank slots is 0 F and it's converting it to C. Now how do I get it to not do that.
