Help needed would this be an IF statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pano - 11 Feb 2007 03:03 GMT

How do I write this formula I have been given the first part but cant
work out the rest myself

=IF(A1<>"",8.26,"")

If A1 is blank make b1 blank if A1 is not blank put 8.26 in B1 also if
A1 is not blank but J1 is blank enter blank in B1

thanks Stephen

Reply to this Message

T. Valko - 11 Feb 2007 03:14 GMT

Try this:

=IF(A1="","",IF(AND(A1<>"",J1=""),"",8.26))

Biff

> How do I write this formula I have been given the first part but cant
> work out the rest myself
[quoted text clipped - 5 lines]
>
> thanks Stephen

Reply to this Message

pano - 11 Feb 2007 03:21 GMT

> Try this:
>
[quoted text clipped - 13 lines]
>
> - Show quoted text -

Thanks Biff works perfectly....

Steveo

Reply to this Message

T. Valko - 11 Feb 2007 04:01 GMT

You're welcome. Thanks for the feedback!

Biff

>> Try this:
>>
[quoted text clipped - 17 lines]
>
> Steveo

Reply to this Message

Dave Peterson - 11 Feb 2007 14:07 GMT

I don't think you need the A1<>"" in the =and() portion. You already know that
A1<>"" because of the first test.

Maybe just:

=IF(A1="","",IF(J1="","",8.26))

> Try this:
>
[quoted text clipped - 11 lines]
> >
> > thanks Stephen

Signature

Dave Peterson

Reply to this Message

T. Valko - 11 Feb 2007 18:37 GMT

Yeah, you're right!

Biff

>I don't think you need the A1<>"" in the =and() portion. You already know
>that
[quoted text clipped - 19 lines]
>> >
>> > thanks Stephen

Reply to this Message