IF and AND/OR

[Robert]

Hi everybody,
I hope someone can help me.
I have been trying to build some formulas and I got stuck.
I have 4 colums:

rate(C) billable weight(D) quantity(F) amount(H)

Amount is the calculation of the other 3 colums I made as:
(rate*billable weight)/100 and the colum quantity HAS to remain blank so I
put for line 19:

=IF(F19="",(C19*D19*1)/100,(C19*D19*F19)/100)

and it works great if I need to put a quantity value it will calculate
correctly.

However I realized that sometimes even billable weight (D) AND quantity (F)
has to remain blank and therefore if I use a formula I have to include it as
if BLANK=1.

I hope I explained clearly....sorry for my english!

Can anyone help me?


Regards
Rober

 

[Joe User]

=IF(F19="",(C19*D19*1)/100,(C19*D19*F19)/100) [....]
However I realized that sometimes even billable
weight (D) AND quantity (F) has to remain blank
and therefore if I use a formula I have to include
it as if BLANK=1.

One way:

=IF(C19="",1,C19)*IF(D19="",1,D19)*IF(F19="",1,F19)/100

If C19, D19 and F19 are always 1 or more if they are not blank, then:

=MAX(1,C19)*MAX(1,D19)*MAX(1,F19)/100


----- original message -----