Excel problems?

Question

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?

Answer 1

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%"))