E-Answer.Net

 
  • Increase font size
  • Default font size
  • Decrease font size
Business & Finance

Excel problems

How to calculate the projeced revenue increase for the year 2002
revenue Millions US$ Projected Increaded
Lesss than 30 3%
greather than or
equal to 30 5%

whatif spreadsheet.

Can anyone tell me what function to use in excel plus step by step how to do this?
1 Comments


Mya1500
Votes: +0

You would use the "IF" function. Check Excel help for the steps.

It would look something like this



=IF(B2<30,"3%", IF(B2>=30, "5%"smilies/wink.gif)

report abuse
vote down
vote up

Write comment
 
 
quote
bold
italicize
underline
strike
url
image
quote
quote
smile
wink
laugh
grin
angry
sad
shocked
cool
tongue
kiss
cry
smaller | bigger
 

busy