I need to tell column B if there there is something in column C greater
than zero then use column A figure. Otherwise use A/2.

A B C D
Savings Shared Flat fee TOTAL
$52.66 $26.33 $15.00 $15.00

Can anyone help me with this formula?

Thanks in advanced.

=A2/if(c0,2,1)

"Admiral70" wrote:

I need to tell column B if there there is something in column C greater
than zero then use column A figure. Otherwise use A/2.

A B C D
Savings Shared Flat fee TOTAL
$52.66 $26.33 $15.00 $15.00

Can anyone help me with this formula?

Thanks in advanced.

=a1/if(c10,2,1)

apologies if this came through 2 times



"Admiral70" wrote:

I need to tell column B if there there is something in column C greater
than zero then use column A figure. Otherwise use A/2.

A B C D
Savings Shared Flat fee TOTAL
$52.66 $26.33 $15.00 $15.00

Can anyone help me with this formula?

Thanks in advanced.

Duke -
I believe you have the 2 and the 1 switched around in your formula, it
should be:

=a1/if(c10,1,2)

--
Regards,
db


"Duke Carey" wrote:

=a1/if(c10,2,1)

apologies if this came through 2 times



"Admiral70" wrote:

I need to tell column B if there there is something in column C greater
than zero then use column A figure. Otherwise use A/2.

A B C D
Savings Shared Flat fee TOTAL
$52.66 $26.33 $15.00 $15.00

Can anyone help me with this formula?

Thanks in advanced.

Admiral -
This will work for the first row, drag down for however far you need the
range to be:

=IF(C10,A1,A1/2)

--
Regards,
db


"Admiral70" wrote:

I need to tell column B if there there is something in column C greater
than zero then use column A figure. Otherwise use A/2.

A B C D
Savings Shared Flat fee TOTAL
$52.66 $26.33 $15.00 $15.00

Can anyone help me with this formula?

Thanks in advanced.

Thanks for such a quick response. I think this will work for what I
need.

Thanks again.

This works good, now what if G28 is a negative number. Is there a way
to modify the following formula to not show a negative and instead show
a - (dash)?

=IF(K280,G28,G28/2)

I'm a little confused by what you mean. Do you mean as it stands now Excel
is showing parenthesis for negative numbers? For example:

It is showing: ($40.45)
You want it to show: $-40.45

--
Regards,
db


"Admiral70" wrote:

This works good, now what if G28 is a negative number. Is there a way
to modify the following formula to not show a negative and instead show
a - (dash)?

=IF(K280,G28,G28/2)

No, sorry, if it shows ($40.45) then I want to show just a - no # at
all, not even a zero.

Thanks for clarifying.

Try:

=IF(G28<0,0,IF(K280,G28,G28/2))

and format the cell as Accounting with no currency sign if necessary but
note that the value stored in the cell will now be zero.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Admiral70" wrote in message
ups.com...
This works good, now what if G28 is a negative number. Is there a way
to modify the following formula to not show a negative and instead show
a - (dash)?

=IF(K280,G28,G28/2)

Just a little update to this formula, you can do the same thing without
having to format it as accounting:

=IF(G28<0,"-",IF(K280,G28,G28/2))

--
Regards,
db


"Sandy Mann" wrote:

Try:

=IF(G28<0,0,IF(K280,G28,G28/2))

and format the cell as Accounting with no currency sign if necessary but
note that the value stored in the cell will now be zero.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Admiral70" wrote in message
ups.com...
This works good, now what if G28 is a negative number. Is there a way
to modify the following formula to not show a negative and instead show
a - (dash)?

=IF(K280,G28,G28/2)

Yes I did think of suggesting that but is the cell is referenced in a
formula it will cause the formula to return #VALUE!

--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk


"db" wrote in message
...
Just a little update to this formula, you can do the same thing without
having to format it as accounting:

=IF(G28<0,"-",IF(K280,G28,G28/2))

--
Regards,
db


"Sandy Mann" wrote:

Try:

=IF(G28<0,0,IF(K280,G28,G28/2))

and format the cell as Accounting with no currency sign if necessary but
note that the value stored in the cell will now be zero.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Admiral70" wrote in message
ups.com...
This works good, now what if G28 is a negative number. Is there a way
to modify the following formula to not show a negative and instead show
a - (dash)?

=IF(K280,G28,G28/2)

Ok, so the number is zero, but will show a dash. Is the dash part of
the Accounting format?

Thanks

Yes, in Accounting format a zero is shown as a dash.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Admiral70" wrote in message
oups.com...
Ok, so the number is zero, but will show a dash. Is the dash part of
the Accounting format?

Thanks

=IF(C0,A,A/2)


Admiral70 Wrote:
I need to tell column B if there there is something in column C greater
than zero then use column A figure. Otherwise use A/2.

A B C D
Savings Shared Flat fee TOTAL
$52.66 $26.33 $15.00 $15.00

Can anyone help me with this formula?

Thanks in advanced.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=398295

This works good, now what if G28 is a negative number. Is there a way
to modify the following formula to not show a negative and instead show

a - (dash)?


=IF(K280,G28,G28/2)


Any ideas? Thanks