Use the IF function for Excel?

How to use the actual IF operate for Exceed to enter a formula that displays internet of $2.00 when the certain date is usually a Monday, plus $2.55 if it’s actually not.

This formula will require the day in A1 as well as determine the afternoon of the particular week then apply your own conditions.

=IF(WEEKDAY(A1)=2, 2, 2.55) Data format as forex.

Monday may be the second day belonging to the week so in the event the weekday = ONLY TWO then the particular statement is true and $2.00 is returned.Some other value will certainly return the extra worthiness of $2.FITYFIVE.

For instance purposes, cell B1 might be where the term “Monday” may well or probably are not:

=IF(B1=”MONDAY”, 2, 2.55)

I put my personal formula with cell A1.

Wherever you squeeze formula, you must format of which cell towards the currency.So right check out the cell phone, select foreign money, and ensure it’s COUPLE OF decimal destinations.

If you do not do the following, then ones number is not going to have the $ symbolic representation when this evaluates no matter whether “monday” is there.

What exactly my method is telling is:

In case cell B1 will be Monday, next show myself $2.00.If it’s actually not Monday, next show myself $2.FITYFIVE.