D
Duke
I need a formula that does this:
IF CELL G3 HAS TEXT OF ANY KIND, THEN G34*.15, IF G3 IS BLANK, THEN 0.
Help!!!
IF CELL G3 HAS TEXT OF ANY KIND, THEN G34*.15, IF G3 IS BLANK, THEN 0.
Help!!!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alan
=IF(G3<>0,G34*1.5,0)
Regards,
Alan.
Regards,
Alan.
P
Peo Sjoblom
=IF(AND(ISTEXT(G3),G3<>""),G34*0.15,0)
if you by "text of any kind" mean a number as well
=IF(LEN(G3)>0,G34*0.15,0)
if you by "text of any kind" mean a number as well
=IF(LEN(G3)>0,G34*0.15,0)
P
PCLIVE
=IF(G3="",0,G34*.15)
Regards,
Paul
Regards,
Paul
A
Aladin Akyurek
1.
=(ISTEXT(G3))*(G34*0.15)
2.
=IF(ISTEXT(G3),G34*0.15,0)
=(ISTEXT(G3))*(G34*0.15)
2.
=IF(ISTEXT(G3),G34*0.15,0)
S
Sandy Mann
If you mean text in G1 but ignore numbers and errors then try
=(ISTEXT(G3))*G34*0.15
If you mean any entry in G1 the try:
=(G3<>"")*G34*0.15
--
HTH
Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
=(ISTEXT(G3))*G34*0.15
If you mean any entry in G1 the try:
=(G3<>"")*G34*0.15
--
HTH
Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
S
Sandy Mann
Aladin Akyurek said:1.
=(ISTEXT(G3))*(G34*0.15)
2.
=IF(ISTEXT(G3),G34*0.15,0)
Sandy Mann said:If you mean text in G1 but ignore numbers and errors then try
=(ISTEXT(G3))*G34*0.15
If you mean any entry in G1 the try:
=(G3<>"")*G34*0.15
mmmm....
Going to have to spend less time reading off line..... <g>
Sandy