Quote:
Originally Posted by Charles Kenyon
To Insert an IF Field:
- Type "IF" without the quotation marks and select it.
- Press Ctrl+F9
- Insert your logical test, your truetext and falsetext
|
Great! Thank you guys so much for your help and hints! Finally it works!
I even added check empty cell condition:
Code:
{IF{=A1}= 330 "33x26x20" {IF{=A1}= 250 "25x22x15"{IF{=A1}= 0 "" "39x26x25"}}}
(Sample attached).
But I assume that all of this will take too much time for everyday routine.
So I'd rather go using insert formula with
Macropod's second code:
Code:
=A1-250 \# "'33x26x20'; '39x26x25';'25x22x15'"
Could the check of empty cell be added here as well?