excel courses - excel formattingformular

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - Excel formatting/Formular

excel courses - Excel formatting/Formular

resolvedResolved · Low Priority · Version Standard

Peter has attended:
Access Introduction course

Excel formatting/Formular

When creating a formular dividing a number into 0 result is often Div0, how can this be formatted to produce a 0.

RE: Excel formatting/Formular

Hi Peter. You need to use the IF function to achieve this. Lets say cell A1 contains "2" and A2 contains "0". Put the following formula into A3:

=IF(A2=0,"0",A1/A2)

The IF function looks at A2. If it contains a "0" value it puts a "0" into cell A3. If it doesn't contain a "0", it puts the result of A1/A2 into A3. Voila!

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips


Server loaded in 0.08 secs.