|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
|
|
Thread Tools | Display Modes |
Nov 3rd, 2009, 11:49 PM
|
#3 |
|
Join Date: Mar 2009
Posts: 139
|
Re: If Statement
the formula works fine....
i don't know but somehow it won't work as intended on cells which already has an If formula... let me share my cell formula with you. 1st one is E6 with formula =IF(H6,F6/H6*100,0) 2nd one is G6 with formula =IF(H6,K6/H6*100,0) not H6. the "and" statement was treasted as "or" when =AND(E6>50,G6>33.3333) was applied to cells E6 and G6 |
|
|
| Bookmarks |
| Tags |
| if statement |
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode