Help with formula please

[lvcourtney]

So this is what I am dealing with. When I start, only column N is filled in. I have to calculate 2 different markup prices in the columns to the left. My problem is, the file is many pages long and column N sometimes has blank fields or text, as you can see, so I am unable to just copy a formula to an entire column without getting a bunch of #VALUE's.




Is there a way of writing the formula so that, for M4 for example:

if there is a number in N4, then M4=N4/.55
if N4 is blank, then M4 is blank
if N4 has text, M4=that text?

THANK YOU!!!

 

[AliGW]

In M4:

=IF(ISNUMBER(N4),N4/0.55,IF(ISTEXT(N4),N4,""))

 

[Roderick_E]

Using your conditions...
if there is a number in N4, then M4=N4/.55
if N4 is blank, then M4 is blank
if N4 has text, M4=that text?

=if(isnumber(n4), n4/.55,"")

That only calculates n4/.55 if n4 is a number, otherwise if blank or text, it returns blank

So this is what I am dealing with. When I start, only column N is filled in. I have to calculate 2 different markup prices in the columns to the left. My problem is, the file is many pages long and column N sometimes has blank fields or text, as you can see, so I am unable to just copy a formula to an entire column without getting a bunch of #VALUE's.




Is there a way of writing the formula so that, for M4 for example:

if there is a number in N4, then M4=N4/.55
if N4 is blank, then M4 is blank
if N4 has text, M4=that text?

THANK YOU!!!

 

[lvcourtney]

In M4:

=IF(ISNUMBER(N4),N4/0.55,IF(ISTEXT(N4),N4,""))

ray:

 

[AliGW]