# add IF statement to CEILING function

1. ## add IF statement to CEILING function

I'm looking for some help to include IF into the following formula

=IF (G21=IN), CEILING(((E23*F23*G23)/462)*D23,0.5), IF (G21=CM)CEILING(((E23*F23*G23)/366)*D23,0.5)
Currently it is giving me an error I can't figure out. Appreciate the help

thx
MK

2. ## Re: add IF statement to CEILING function

Maybe?

=IF(G21="IN",CEILING(((E23*F23*G23)/462)*D23,0.5),IF(G21="CM",CEILING(((E23*F23*G23)/366)*D23,0.5),""))

if none are true, a blank is returned.

3. ## Re: add IF statement to CEILING function

As a wild guess of what you're trying to do,

=CEILING(D23 * E23 * F23 * G23 / IF(G21 = "IN", 462, 366), 0.5)

4. ## Re: add IF statement to CEILING function

Perfect. This worked. Much appreciated!

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1