jeudi 28 février 2019

Excel - How to add words to an Excel IF statement

I am creating a spreadsheet for a Dungeons and Dragons game that I run to help measure initiative and turn orders.

The formula I'm trying to do is to convert the rounds passed into real time. 1 Round being 6 seconds, 10 rounds being 1 minute.

I think the math is fine, the problem is adding the words "Seconds" when the value of Rounds passed is equal to 2-9, and greater than 10.

This is the formula I have now: =IF(I3=10,"1 Minute",IF(I3=1,"6 Seconds",IF(I3>1,I3*6+" Seconds")))

(I3 being the Rounds Passed cell)

Aucun commentaire:

Enregistrer un commentaire