Posted to microsoft.public.excel.worksheet.functions

Nate

external usenet poster

Posts: 79

How to: If D4 = Yes then Calculate C4/11, if D4 = no leave blank

Hi everyone,

Basically I am making a purchases journal on excel and I want to be able to
click a check box or just type in Y/N and if the box is checked or it is 'Y'
then excel will divide the price by 11 and display in say E4.
If the box is unchecked, it displays blank or N/A or something to that
effect.

Thankyou

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
leave cells blank #2	Mary	Excel Worksheet Functions	2	September 1st 05 11:29 PM
Leave Cells Blank	Mary	Excel Worksheet Functions	3	September 1st 05 09:39 PM
leave a cell blank	nicolas	Excel Worksheet Functions	1	August 2nd 05 01:55 PM
To Leave Cell blank Please	Steved	Excel Worksheet Functions	7	August 1st 05 12:20 AM
LEAVE BLANK IF NEGATIVE	Carolan	Excel Worksheet Functions	3	January 14th 05 05:01 PM

All times are GMT +1. The time now is 11:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us