LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jenna
 
Posts: n/a
Default Can a value from a different cell be the false answer in =If quest

I want to write an If statement where if the answer is false, the exact value
from another cell will go into the cell with the formula.

For example.

In H6 i would write

=If(E6=not given, "", "E6")

where if E6 = not given nothing would appear in H6, but if it did NOT = not
given then the value in E6 would go into H6

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
How do I compare cells and if FALSE compare to next cell in EXCEL Cindie Excel Worksheet Functions 0 March 24th 06 05:29 PM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
How do I multiply 1 cell x 1 cell and answer in 3rd cell? Melody Excel Worksheet Functions 3 January 30th 06 01:51 AM
Shorten a Macro mully Excel Discussion (Misc queries) 7 December 30th 05 05:52 PM


All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"