Need formula to give whole number

B

Bill Kuunders

Try this in E18.

=(IF(E17<=250,E17*1.25,IF(E17>=500,E17*1.5,E17*1.35)))

need to format E18 as currency with two decimals.

regards
Bill K
 
B

Bill Kuunders

as you were

enter in e18

=(IF(E17<=250,E17*0.25,IF(E17>=500,E17*0.5,E17*0.35)))

to show the percentage only and not E17 plus the percentage
regards
Bill K
 

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

Autonumber field in Excel that behaves the same as Access 0
Calculate horses age as at 1 August 6
Excel Experts Challenge 2
Finding the weighted average of text that have been given values 1
Display weeks from a Milestone 0
Find Exact Match using INDEX, MATCH 3
FOrmula Copy and Paste 3
Finding the proper style field and the numbered paragraph value within the style 0

Top