Kimmi
Slayer
- Joined
- Sep 18, 2005
- Posts
- 9,733
- Location
- Faroe Islands
- Avatar Name
- Kimmi Kimmi EFnet
Hey hey!
I`m in need of some assistance with excel programming.
I would like to make this statement.
Cell A1:
IF A1<7,5 THEN print "invalid value" IN B1 _or_ IF 16>A1>7,5 THEN print value of A1 IN B1 _or_ IF A1>16 THEN print "invalid value" IN B1
In plain text:
If the value that I type in A1 is less then 7,5 then I want the text in B1 to say "invalid value".
If the value that I type in A1 is 7,5 to 16 then I want that value displayed in B1.
If the value that I type in A1 is above 16 then I want the text in B1 to say "invalid value".
Ive been looking at excel help sites, but I have noe clue what Im doing
I`m in need of some assistance with excel programming.
I would like to make this statement.
Cell A1:
IF A1<7,5 THEN print "invalid value" IN B1 _or_ IF 16>A1>7,5 THEN print value of A1 IN B1 _or_ IF A1>16 THEN print "invalid value" IN B1
In plain text:
If the value that I type in A1 is less then 7,5 then I want the text in B1 to say "invalid value".
If the value that I type in A1 is 7,5 to 16 then I want that value displayed in B1.
If the value that I type in A1 is above 16 then I want the text in B1 to say "invalid value".
Ive been looking at excel help sites, but I have noe clue what Im doing