Nested IF functions

I

is2cu

I cannot seem to get my head around creating this function. I am trying to
create a pricing algorithm and cannot figure out the correct sequence of
writing the function. Here is what i am up against:

IF J3<$24.99 then add J3 plus $10.00
IF J3>$25.00 but < $49.99 then add J3 plus $15.00
IF j3>$50.00 then add J3 plus $20.00

Can this be written to one cell and if so how?
 
M

Mike H

Hi,

You question lacka clarity

IF J3>$25.00 but < $49.99 then add J3 plus $15.00
IF j3>$50.00 then add J3 plus $20.00

what if J3=50? I have assumed you meant >=50

=LOOKUP(J3,{0,25,50},{10,15,20})+J3

Mike
 

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

Nested IF with a possible SUM? 1
Nested IF function 3
Page numbering with Merged Document and IF statements 1
I'am not sure if this is a (=if) problem 4
Why doesn't writing a nested IF function work? 1
IF function says too many nested 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Translating Formulas to Functions 0

Top