Thanks for the feedback Andy.
Glad you got it sorted out in the end.

Regards

Roger Govier


Andy JL wrote:
Thank you one and all for all the help that you have given me over the last
few days, as a result I have gained some very useful knowledge of formulas,
and I gave an all siging and dancing Invoice for my sons carpet fitting work.

Thanks agian,
Andy JL

"Roger Govier" wrote:


Hi Andy

One way
=IF(ISBLANK(C24),"",IF(C24="-",100,IF(OR(C24="C",C24="M",C24="V"),D24*E24)) )

This will return nothing if C24 is empty,
if c24 is something but not any of the tested values, but D24 and E24 are
blank, then it would return 0

Regards

Roger Govier


Andy JL wrote:

Roger,

Thank you for that - works very well thank you, sorry for the delay in
replying ,

Can you assist me with this - I currently have worked out a formula -
=IF(C24="-",100,IF(OR(C24="C",C24="M",C24="V"),D24*E24)) this I'm putting in
Column F, but when there is nothing in Columns C,D,or E i get the word FALSE
in the column F row, can you shed some light on this, Have tried putting ,"0"
and "" etc at the end but withour any joy.
I( would be greatful of any help PLEASE.

Andy JL

"Roger Govier" wrote:



Hi Andy

Try=IF(A1="D","DAY",IF(A1="M",8,IF(OR(A1="C",A 1="V"),2,"")))
I know a good plasterer!!!<bg


Regards

Roger Govier


Andy JL wrote:


Adam,

Been trying most the afternoon without success , how do I Put -
IF(A1="D","DAY", into =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,""))

I'm getting a very sore head and the wall is not looking so good either!!!!!!!

Thank You

Andy JL

"Adam Kroger @hotmail.com" wrote:




Put " marks around DAY

If (A1="D","DAY", <whatever)

Adam

"Andy JL" wrote in message
...



Bernard,
To your formula below I want to add if A1=D then it = the word "DAY", I
have
been trying allways but can not get it to enter the word"DAY" even if i
cut
the formula down to If (A1="D",DAY ....... I can do it with a number
instead
of the "DAY" but I can not put it in to you formula. I think I have
expalinded myself!!!

Thanbk you

Andy JL

"bernard liengme" wrote:




Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,""))
If A1 is not M,C or V you get a blank
Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,0))
If A1 is not M,C or V you get a zero
Not case sensitive
best wishes
Bernard

"Andy JL" wrote in message
...



Hi.

I want a formula to enter into a cell - if A1 is "M" then I want C1 to
be
£8.00 or
if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I
can
enter in Cell C1 to make display either £2.00 or £8.00 depending on wat
is
in
A1 -

Thanks for any help

Andy JL