IF function?

C

CindyH

Pardon me, but I'm so confused on how to do this. Here's what I want to do
and God bless anyone who can help me.

I have two worksheets that I'm using.
Sheet1, Sheet2

I don't know how else to describe this so I'll do my best here.

I want Sheet2!B2 to look on Sheet1!B2 and do the following:
If Sheet1!B2 is blank, Sheet2!B2 should also be blank.
If Sheet1!B2 is 1-5, then I want Sheet2!B2 to say 9.47
If Sheet1!B2 is 6 or more, then I want Sheet2!B2 to say 8.41

Any help is greatly appreciated. It's probably very simple but I can't seem
to get that third item in there.

Cindy
 
H

Harald Staff

Hi Cindy

Assuming that "6 or more" is "anything but empty or <=5":

=IF(Sheet1!B2="","",IF(Sheet1!B2<=5,9.42,8.41))

HTH. Best wishes Harald
 
C

CindyH

Assuming that "6 or more" is "anything but empty or <=5":
=IF(Sheet1!B2="","",IF(Sheet1!B2<=5,9.42,8.41))

HTH. Best wishes Harald
Click to expand...

Goodness you're fast! It worked like a dream.
Thank you, thank you, thank you!

Cindy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Countif and sumif combination problem 2
if-then statements or functions 3
how do I create a nonadjacent series for autofill to go by? 3
Lookup Function help 1
First column of range in VLOOKUP contains formula 2
Can you display entire rows that match a certain criteria... 1
Copying formulas from a row down to a row across 1

Top